Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> writes:
> I need to to disconnect any other users and do "vacuum full verbose
> analyze" "reindex database" and reindex all tables. And for these I will
> stop the postmaster and run a stand alone backend.
I think the real problem here is stone-age maintenance procedures ;-)
You shouldn't need to do vacuum full on a regular basis, and you
shouldn't need to do reindexing on a regular basis either. Update
to 7.4, if you aren't using it already, and replace these procedures
by plain vacuums run often enough to keep the DB from bloating (a look
at your FSM parameters would be advisable too).
> I figured that doing a nightly backup would be a good idea and running
> it in stand alone mode will speed up the process drastically.
No it won't.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Shelby Cain||Date: 2004-08-24 15:12:12|
|Subject: Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming |
|Previous:||From: Tom Lane||Date: 2004-08-24 14:57:13|
|Subject: Re: Bad planner results |