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.

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].


Oleg Bartunov, Research Scientist, Head of AstroNet (,
Sternberg Astronomical Institute, Moscow University, Russia
phone: +007(495)939-16-83, +007(495)939-23-83

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to