Re: [HACKERS] PostgreSQL Core Team
Congratulations. Jeremiah Peschka Microsoft SQL Server MVP MCITP: Database Developer, DBA On Apr 27, 2011 11:49 AM, "Dave Page" wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > > Magnus has been a contributor to PostgreSQL for over 12 years, and > played a major part in the development and ongoing maintenance of the > native Windows port, quickly becoming a committer to help with his > efforts. He's one of the project's webmasters and sysadmins and also > contributes to related projects such as pgAdmin. In his spare time, he > serves as President of the Board of PostgreSQL Europe. > > Regards, Dave. > > -- > Dave Page > PostgreSQL Core Team > http://www.postgresql.org/ > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] k-neighbourhood search in databases
On Sunday, April 10, 2011 at 3:18 AM, Oleg Bartunov wrote: Wow, custom solution for 2008 still much faster Denali 2011 solution. > Also, what's about not spatial data types ? > In our approach, we can provide knn for any datatype, which has GiST index > and distance method. > There are a number of workarounds (custom data types, mainly) that can be done in SQL Server, but the spatial datatypes themselves are .NET datatypes that ship with SQL Server and I'm pretty sure the methods will only work with the spatial types. The other types are the usual primitives that we all know and love and won't respond to .NET method invocation in the database. -- Jeremiah Peschka Microsoft SQL Server MVP MCITP: Database Developer, DBA > Oleg > On Fri, 8 Apr 2011, Jeremiah Peschka wrote: > > > > > On 4/8/11 5:21 AM, Oleg Bartunov wrote: > > > Hi there, > > > > > > I'm interesting if other databases provides built-in effective knn > > > search ? Google didn't help me. > > SQL Server provides some knn search functionality[1] with enhancements > > coming this November in SQL 11[2]. > > > > [1]: http://blogs.msdn.com/b/isaac/archive/2008/10/23/nearest-neighbors.aspx > > [2]: > > http://www.sqlskills.com/BLOGS/BOBB/post/The-nearest-neighbor-optimization-in-SQL-Server-Denali.aspx > > Regards, > Oleg > _ > Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), > Sternberg Astronomical Institute, Moscow University, Russia > Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(495)939-16-83, +007(495)939-23-83 >
Re: [HACKERS] k-neighbourhood search in databases
On 4/8/11 5:21 AM, Oleg Bartunov wrote: > Hi there, > > I'm interesting if other databases provides built-in effective knn > search ? Google didn't help me. SQL Server provides some knn search functionality[1] with enhancements coming this November in SQL 11[2]. [1]: http://blogs.msdn.com/b/isaac/archive/2008/10/23/nearest-neighbors.aspx [2]: http://www.sqlskills.com/BLOGS/BOBB/post/The-nearest-neighbor-optimization-in-SQL-Server-Denali.aspx -- Jeremiah Peschka Microsoft SQL Server MVP MCITP: Database Developer, DBA