Re: BUG #5967: Db maintainace - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #5967: Db maintainace
Date
Msg-id 4D9DF029.7040905@hogranch.com
Whole thread Raw
In response to Re: BUG #5967: Db maintainace  ("Halli, Savita" <Savita.Halli@ca.com>)
List pgsql-bugs
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
weneed 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.

pgsql-bugs by date:

Previous
From: "Halli, Savita"
Date:
Subject: Re: BUG #5967: Db maintainace
Next
From: Brendan Jurd
Date:
Subject: Re: Failed assert ((data - start) == data_size) in heaptuple.c