pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ben Chobot <bench@silentmedia.com>
To: Meena_Ramkumar <winmeena_ramkumar@yahoo.co.in>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres DB maintainenance - vacuum and reindex
Date: Tue, 16 Mar 2010 10:06:41 -0700
Message-ID: <5F413149-F922-4CC4-952E-CBDC40DBD62F@silentmedia.com> (raw)
In-Reply-To: <27913694.post@talk.nabble.com>
References: <27913694.post@talk.nabble.com>

Autovacuum is your friend for minimal downtime. It is configurable to let you adjust how invasive it will be, and you can have different settings per table if you wish.

As for the reindex, why do you think you will be reindexing regularly?

On Mar 15, 2010, at 10: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?
> -- 
> View this message in context: http://old.nabble.com/Postgres-DB-maintainenance---vacuum-and-reindex-tp27913694p27913694.html
> Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
> 
> 
> -- 
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance




view thread (4+ messages)  latest in thread

Message-ID: <5F413149-F922-4CC4-952E-CBDC40DBD62F@silentmedia.com>
Permalink:  ../5F413149-F922-4CC4-952E-CBDC40DBD62F@silentmedia.com/
Also on:    postgresql.org/message-id/5F413149-F922-4CC4-952E-CBDC40DBD62F@silentmedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: bench@silentmedia.com, winmeena_ramkumar@yahoo.co.in
  Subject: Re: Postgres DB maintainenance - vacuum and reindex
  In-Reply-To: <5F413149-F922-4CC4-952E-CBDC40DBD62F@silentmedia.com>
  References: <27913694.post@talk.nabble.com> <5F413149-F922-4CC4-952E-CBDC40DBD62F@silentmedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox