Re: BUG #5967: Db maintainace

Hi Depesz

I understand that this is not a bug but I was not aware of any other way to get the information so I reported here.
Could you please let me know how frequently we need to go for db maintainance?

Thanks
Savita

-----Original Message-----
From: depesz(at)depesz(dot)com [mailto:depesz(at)depesz(dot)com]
Sent: Thursday, April 07, 2011 6:38 PM
To: Halli, Savita
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #5967: Db maintainace

On Thu, Apr 07, 2011 at 07:38:49AM +0000, Savita wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5967
> Logged by: Savita
> Email address: savita(dot)halli(at)ca(dot)com
> PostgreSQL version: 8.3.5
> Operating system: Linux
> Description: Db maintainace
> Details:
>
> Hi
>
> We are using the postgres database and would like to know what are the db
> maintainance activity need to be carried out for postgres and how
> frequently.

First of all - this is not a bug, so please don't report it as a bug.

Second of all - did you read this part of documentation:
http://www.postgresql.org/docs/8.3/interactive/maintenance.html

Best regards,

depesz