Postgres Pro
Downloads
Home   >   mailing lists

Re: Order of Daily VACUUM, CLUSTER, REINDEX - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Order of Daily VACUUM, CLUSTER, REINDEX
Date
Msg-id 2f4958ff1003190805g1776932tc6a633d9ed8abf87@mail.gmail.com
Whole thread Raw
In response to Order of Daily VACUUM, CLUSTER, REINDEX  (APseudoUtopia <apseudoutopia@gmail.com>)
List pgsql-general
Tree view
yes, if you really want to do it - analyze should be running following cluster, as it moves data around.
plus, with 8.4 autovacuum should do the job.

pgsql-general by date:

Previous
From: APseudoUtopia
Date:
Subject: Order of Daily VACUUM, CLUSTER, REINDEX
Next
From: Raymond O'Donnell
Date:
Subject: Re: Many-to-many problem