Re: HouseKeeping and vacuum Questions

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: "Ow Mun Heng" <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: HouseKeeping and vacuum Questions
Date: 2007-12-14 08:35:53
Message-ID: 7be3f35d0712140035o6471edacld9457eb04d8d5899@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bookman bookman 2007-12-14 09:29:21 How can i deal with "\n" when copy tables from sqlserver2005 to postgre?
Previous Message Tom Lane 2007-12-14 07:51:57 Re: Need to find out which process is hitting hda