Re: KNNGIST next step: adjusting indexAM API - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: KNNGIST next step: adjusting indexAM API
Date
Msg-id 87d3pl6bcz.fsf@hi-media-techno.com
Whole thread Raw
In response to KNNGIST next step: adjusting indexAM API  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: KNNGIST next step: adjusting indexAM API  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Lastly, I'm pretty un-thrilled with the way that the KNNGIST patch
> implements the interface to the opclass-specific hook functions.
> Seems like it would be cleaner to leave the Consistent function alone
> and invent a new, separate hook function for processing ORDER BY.
> Is there a strong reason for having both things done in one call,
> or was that just done as a byproduct of trying to cram all the data
> into one ScanKey array?

IIRC, the goal here was to be able to benefit from KNN GiST from
existing GiST indexes as soon as you restart the server with the new
code compiled in. I'm not sure it's that important in the context of
preparing 9.1. It seems that pg_upgrade already has to issue a reindex
script for GiST indexes.

Now, of course, that's memories from Royal-Oak sessions, so it might be
all wrong too :)

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: ghatpande@vsnl.net
Date:
Subject: Proposal: First step towards Intelligent,integrated database
Next
From: Dann Corbit
Date:
Subject: Re: Proposal: First step towards Intelligent,integrated database