Re: KNN-GiST and Informix - Mailing list pgsql-advocacy

From David Fetter
Subject Re: KNN-GiST and Informix
Date
Msg-id 20110611150904.GA11438@fetter.org
Whole thread Raw
In response to KNN-GiST and Informix  (Josh Berkus <josh@agliodbs.com>)
Responses Re: KNN-GiST and Informix
List pgsql-advocacy
On Thu, Jun 09, 2011 at 02:46:54PM -0700, Josh Berkus wrote:
> All,
>
> At pgCon, Tim Child pointed out that Informix had some kind of
> indexed "near()" function back in 1999.  Does anyone know how this
> was implemented?  Is it acutually the first implementation of KNN?

The document below talks about functions for doing this:

http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.spatial.doc/sii-funcs-86146.htm

> And if so, does DB2 have it now?

Unsure.  I did a quick search and only found Informix references for
it.  They're using R-Trees, so our method, which doesn't, could be a
differentiator.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-advocacy by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Crediting reviewers & bug-reporters in the release notes
Next
From: Oleg Bartunov
Date:
Subject: Re: KNN-GiST and Informix