Re: HouseKeeping and vacuum Questions - Mailing list pgsql-general

From Harald Armin Massa
Subject Re: HouseKeeping and vacuum Questions
Date
Msg-id 7be3f35d0712140035o6471edacld9457eb04d8d5899@mail.gmail.com
Whole thread Raw
In response to HouseKeeping and vacuum Questions  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
Responses Re: HouseKeeping and vacuum Questions
List pgsql-general
Ow Mun Heng,

The current issue which prompted me to do such housekeeping is due to
long database wide vacuum time. (it went from 2 hours to 4 hours to 7
hours)

If vacuum takes to long, you are doing it not often enough. You should use autovacuum, you should be able to express the delta between two vacuums in seconds or minutes, not hours or days.

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Need to find out which process is hitting hda
Next
From: Ow Mun Heng
Date:
Subject: Re: HouseKeeping and vacuum Questions