Bill Moran wrote: > In response to "Gauthier, Dave" <dave.gauthier@xxxxxxxxx>: > > > 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
