Re: OID Usage - Mailing list pgsql-general

From Tom Lane
Subject Re: OID Usage
Date
Msg-id 12295.1105826807@sss.pgh.pa.us
Whole thread Raw
In response to Re: OID Usage  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> 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?

It's still on the to-do list.  I ws envisioning that it would switch
strategies based on how many tuples it needed to move --- the REINDEX
is only a win if you're moving a large fraction of the table.  But the
details are all still TBD.

            regards, tom lane

pgsql-general by date:

Previous
From: Berteun Damman
Date:
Subject: Re: Pgsql taking a *lot* of CPU time (unkillable).
Next
From: Bo Lorentsen
Date:
Subject: Re: Index optimization ?