Re: KNN-GiST and Informix

From: David Fetter <david(at)fetter(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: KNN-GiST and Informix
Date: 2011-06-11 15:09:04
Message-ID: 20110611150904.GA11438@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Oleg Bartunov 2011-06-11 18:17:23 Re: KNN-GiST and Informix
Previous Message Bruce Momjian 2011-06-11 14:08:07 Re: Crediting reviewers & bug-reporters in the release notes