Re: OID Usage - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: OID Usage
Date
Msg-id 20050115213620.GC26259@dcc.uchile.cl
Whole thread Raw
In response to Re: OID Usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: OID Usage  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: OID Usage  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sat, Jan 15, 2005 at 04:21:24PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <decibel@decibel.org> writes:
> > Out of curiosity, what clears out the old index tuples? Vacuum?
>
> Right.

Which reminds me that you wanted to make VACUUM FULL do the equivalent
of a REINDEX instead of retail deletion of index entries ... is that
still the idea?  Would it do that always, or only under certain
conditions?

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Some men are heterosexual, and some are bisexual, and some
men don't think about sex at all... they become lawyers" (Woody Allen)

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Index optimization ?
Next
From: ntinos@aueb.gr
Date:
Subject: Re: PQisBusy() always returns TRUE