Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Jeremiah Peschka
Congratulations.

Jeremiah Peschka
Microsoft SQL Server MVP
MCITP: Database Developer, DBA
On Apr 27, 2011 11:49 AM, Dave Page dp...@postgresql.org 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

2011-04-10 Thread Jeremiah Peschka
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

2011-04-08 Thread Jeremiah Peschka

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