Skip site navigation (1) Skip section navigation (2)

Re: GIN - Generalized Inverted iNdex. Try 3.

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>,Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>,Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIN - Generalized Inverted iNdex. Try 3.
Date: 2006-04-27 18:53:44
Message-ID: 44511338.6060507@sigaev.ru (view raw or flat)
Thread:
Lists: pgsql-hackers
> The ideal thing would be for GIN to return a count of the number of
> distinct heap tuples referenced by the entries in the index, but I
> suppose that would be impractical for VACUUM to compute.

Of course, in this case we should collect heap pointers in memory..

-- 
Teodor Sigaev                                   E-mail: teodor(at)sigaev(dot)ru
                                                    WWW: http://www.sigaev.ru/

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-04-27 18:53:56
Subject: Re: Logging pg_autovacuum
Previous:From: Larry RosenmanDate: 2006-04-27 18:40:57
Subject: Re: Logging pg_autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group