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.halli@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 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

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@depesz.com [mailto:depesz@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 +0000, Savita wrote:

The following bug has been logged online:

Bug reference: 5967
Logged by: Savita
Email address: savita.halli@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 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

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 ask there

i would guess that -general, or -admin would be ok.

Could you please let me know how frequently we need to go for db maintainance?

sorry, not sure what you mean by "to go for db maintainace".

did you read the maintenance chapter in docs?

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

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).

Thanks
Savita

-----Original Message-----
From: depesz@depesz.com [mailto:depesz@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 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 ask there

i would guess that -general, or -admin would be ok.

Could you please let me know how frequently we need to go for db maintainance?

sorry, not sure what you mean by "to go for db maintainace".

did you read the maintenance chapter in docs?

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

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
matter, how often do you have to wash your car? the answer, my
friends, is it depends on far too many factors for a generic answer.

with autovacumn in place and with your database reasonably well tuned to
your application requirements, there may be NO need for scheduled
regular maintenance, other than backups.

but, again, this would far better be discussed on the -general or -admin
email lists, not on -bugs.

Hi

Thanks for the reply and sorry for delayed query.

How frequently I mean is

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?

Thanks
Savita

-----Original Message-----
From: depesz@depesz.com [mailto:depesz@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 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 ask there

i would guess that -general, or -admin would be ok.

Could you please let me know how frequently we need to go for db maintainance?

sorry, not sure what you mean by "to go for db maintainace".

did you read the maintenance chapter in docs?

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

On Wed, May 18, 2011 at 12:16 AM, Halli, Savita <Savita.Halli@ca.com> 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 version of postgres, better you can do is
configure autovacuum and let it do most of the job... and by a recent
version i mean at least 8.3 (preferable 8.4 or superior)

btw, any new question you have please send it to
pgsql-general@postgresql.org or another one that fits more with the
question from the page Hubert show you

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL