Re: [PATCHES] GIN improvements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <greg(dot)stark(at)enterprisedb(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] GIN improvements
Date: 2008-12-03 14:35:33
Message-ID: 7855.1228314933@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Greg Stark <greg(dot)stark(at)enterprisedb(dot)com> writes:
> If we do this though it would be really nice to do it at a higher
> level than the indexam. If we could do it for any indexam that
> provides a kind of bulk insert method that would be great.

> I'm just not sure how to support all the indexable operators for the
> various indexams on the local buffered list.

In principle, just return all those TIDs marked "lossy, please recheck".
This is a bit brute-force but I'm not sure any useful optimization is
possible.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hitoshi Harada 2008-12-03 14:42:56 Re: tuplestore potential performance problem
Previous Message Simon Riggs 2008-12-03 14:33:00 Re: Sync Rep: First Thoughts on Code

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2008-12-03 16:40:17 Re: [PATCHES] GIN improvements
Previous Message Greg Stark 2008-12-03 09:40:07 Re: [PATCHES] GIN improvements