On Mon, Mar 15, 2010 at 11:30 PM, Meena_Ramkumar <winmeena_ramkumar@xxxxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
