Re: knngist patch support

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Teodor Sigaev <teodor@sigaev.ru>, Oleg Bartunov <oleg@sai.msu.su>, tomas@tuxteam.de, "Ragi Y. Burhum" <rburhum@gmail.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>

Date: 2010-02-13T18:31:44Z

Lists: pgsql-hackers

Attachments

syscache5-v1.patch (application/octet-stream) patch v1

On Sat, Feb 13, 2010 at 1:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Teodor Sigaev <teodor@sigaev.ru> writes:
>> I see your point. May be it's better to introduce new system table? pg_amorderop
>> to store ordering operations for index.
>
> We could, but that approach doesn't scale to wanting more categories
> in the future --- you're essentially decreeing that every new category
> of opclass-associated operator will require a new system catalog,
> along with all the infrastructure needed for that.  That guarantees
> that the temptation to take shortcuts will remain high.

Yeah.  PFA a patch to allow 5-key syscaches.

...Robert