Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: VACUUMs take twice as long across all nodes
- From: Vivek Khera <vivek(at)khera(dot)org>
- To: "Pgsql-Performance ((((E-mail))))" <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: VACUUMs take twice as long across all nodes
- Date: Thu, 2 Nov 2006 16:41:35 -0500
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:
smime.p7s
Description: S/MIME cryptographic signature
- Prev by Date: Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
- Next by Date: Re: Locking vs. Exceptions
- Previous by thread: Setting "nice" values
- Next by thread: profiling PL/pgSQL?
- Indexes: