Postgres Pro
Downloads
Home   >   mailing lists

Re: "Healing" a table after massive updates - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: "Healing" a table after massive updates
Date
Msg-id 20080911144100.GC9492@alvh.no-ip.org
Whole thread Raw
In response to Re: "Healing" a table after massive updates  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: "Healing" a table after massive updates
List pgsql-general
Tree view 
Bill Moran wrote:
> In response to "Gauthier, Dave" <dave.gauthier@intel.com>:
>
> > I might be able to answer my own question...
> >
> > vacuum FULL (analyze is optional)
>
> CLUSTER _may_ be a better choice, but carefully read the docs regarding
> it's drawbacks first.  You may want to do some benchmarks to see if it's
> really needed before you commit to it as a scheduled operation.

What drawbacks?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: "Healing" a table after massive updates
Next
From: Bill Moran
Date:
Subject: Re: "Healing" a table after massive updates