Re: Postgres DB maintainenance - vacuum and reindex

On Mon, Mar 15, 2010 at 11:30 PM, Meena_Ramkumar
 wrote:
>
> How to run vacuumdb and reindex for Postgres DB in a non-stop server? Will it
> be made without shutting the server? If so, then what will be performance
> degradation percentage?

vacuum can be tuned by the various vacuum_* parameters in the
postgresql.conf file to have little or no impact on other processes
running.  Depending on your IO subsystem, you can tune it up or down
to fit your needs (speed versus impact on other processes).  reindex
however tends to be more intrusive to the system, and may cause some
performance degradation, which will be very dependent on your IO
subsystem (i.e. a single 7200RPM SATA drive system is more likely to
notice and be slowed down by reindexing than a 48 disk 15krpm SAS
RAID-10 array.

The more important question is what problem are you trying to solve,
and are there other, better approaches than the ones you're trying.
Without more info, no one can really say.