Re: [BUGS] BUG #5967: Db maintainace

2011-05-18 Thread Jaime Casanova
On Wed, May 18, 2011 at 12:16 AM, Halli, Savita wrote: > > When we need to rum vacuumdb and reindexdb commands, would like to know how > often we need to perform these ooperation? Is it > once in a week, month or other? > correct answer is: depends on your work load... if you have a recent versi

Re: [BUGS] BUG #5967: Db maintainace

2011-05-18 Thread Halli, Savita
...@depesz.com [mailto:dep...@depesz.com] Sent: Thursday, April 07, 2011 7:06 PM To: Halli, Savita Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5967: Db maintainace On Thu, Apr 07, 2011 at 06:50:16PM +0530, Halli, Savita wrote: > Hi Depesz > > I understand that this is not a bug but

Re: [BUGS] BUG #5967: Db maintainace

2011-04-07 Thread John R Pierce
On 04/07/11 6:53 AM, Halli, Savita wrote: Yes, I am going through that. Its mentioned that some of the commands need to be run. My question is how frequently we need to run those commands(commands for db maintainance). how frequently do you need to do file system maintenance? or for that m

Re: [BUGS] BUG #5967: Db maintainace

2011-04-07 Thread Halli, Savita
, 2011 7:06 PM To: Halli, Savita Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5967: Db maintainace On Thu, Apr 07, 2011 at 06:50:16PM +0530, Halli, Savita wrote: > Hi Depesz > > I understand that this is not a bug but I was not aware of any other way to > get the info

Re: [BUGS] BUG #5967: Db maintainace

2011-04-07 Thread hubert depesz lubaczewski
On Thu, Apr 07, 2011 at 06:50:16PM +0530, Halli, Savita wrote: > 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. http://www.postgresql.org/ click on "community" click on "mailing lists" pick one, subscribe, and a

Re: [BUGS] BUG #5967: Db maintainace

2011-04-07 Thread Halli, Savita
...@depesz.com] Sent: Thursday, April 07, 2011 6:38 PM To: Halli, Savita Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5967: Db maintainace On Thu, Apr 07, 2011 at 07:38:49AM +, Savita wrote: > > The following bug has been logged online: > > Bug reference: 5967 > Logged by:

Re: [BUGS] BUG #5967: Db maintainace

2011-04-07 Thread hubert depesz lubaczewski
On Thu, Apr 07, 2011 at 07:38:49AM +, Savita wrote: > > The following bug has been logged online: > > Bug reference: 5967 > Logged by: Savita > Email address: savita.ha...@ca.com > PostgreSQL version: 8.3.5 > Operating system: Linux > Description:Db maintainace >

[BUGS] BUG #5967: Db maintainace

2011-04-07 Thread Savita
The following bug has been logged online: Bug reference: 5967 Logged by: Savita Email address: savita.ha...@ca.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 wha