Re: VACUUMs take twice as long across all nodes - Mailing list pgsql-performance

From Vivek Khera
Subject Re: VACUUMs take twice as long across all nodes
Date
Msg-id 1B174499-A20E-4452-9BB1-355B73D374D5@khera.org
Whole thread Raw
In response to Re: VACUUMs take twice as long across all nodes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Oct 27, 2006, at 2:07 PM, Tom Lane wrote:

> 8.2, but in existing releases I can't see much you can do about it
> except REINDEX when things get slow.

This will be so nice for me.  I have one huge table with a massive
amount of churn and bulk deletes.  I have to reindex it once every
other month.  It takes about 60 to 75 minutes per index (times two
indexes) else I'd do it monthly.

It shaves nearly 1/3 of the relpages off of the index size.


Attachment

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
Next
From: Benjamin Minshall
Date:
Subject: Re: Locking vs. Exceptions