| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5967: Db maintainace |
| Date: | 2011-04-07 17:11:05 |
| Message-ID: | 4D9DF029.7040905@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brendan Jurd | 2011-04-07 17:46:55 | Re: Failed assert ((data - start) == data_size) in heaptuple.c |
| Previous Message | Tom Lane | 2011-04-07 15:44:25 | Re: BUG #5959: pg_restore --use-list does not always work with a pg_restore generated TOC file |