pg.ddx.io  pgsql-patches@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <greg.stark@enterprisedb.com>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Teodor Sigaev <teodor@sigaev.ru>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [PATCHES] GIN improvements
Date: Wed, 03 Dec 2008 09:35:33 -0500
Message-ID: <7855.1228314933@sss.pgh.pa.us> (raw)
In-Reply-To: <683CE0EA-799C-4644-9C9F-74AECD2BFBDC@enterprisedb.com>
References: <483FD205.4090904@sigaev.ru>
	<486BC501.6060605@sigaev.ru>
	<27880.1215810535@sss.pgh.pa.us>
	<487A6E0C.3090600@sigaev.ru>
	<8993.1216843701@sss.pgh.pa.us>
	<4888A594.6010102@sigaev.ru>
	<490B07BA.6030109@sigaev.ru>
	<492F04D9.5070404@enterprisedb.com>
	<49353081.9030304@sigaev.ru>
	<493541F5.2020401@enterprisedb.com>
	<26721.1228266365@sss.pgh.pa.us>
	<49362DF0.80404@enterprisedb.com>
	<683CE0EA-799C-4644-9C9F-74AECD2BFBDC@enterprisedb.com>

Greg Stark <greg.stark@enterprisedb.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



view thread (74+ messages)  latest in thread

Message-ID: <7855.1228314933@sss.pgh.pa.us>
Permalink:  ../7855.1228314933@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/7855.1228314933@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-patches@postgresql.org
  Cc: tgl@sss.pgh.pa.us, greg.stark@enterprisedb.com, heikki.linnakangas@enterprisedb.com, teodor@sigaev.ru, pgsql-hackers@postgresql.org
  Subject: Re: [PATCHES] GIN improvements
  In-Reply-To: <7855.1228314933@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox