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

From Ow Mun Heng
Subject Re: HouseKeeping and vacuum Questions
Date
Msg-id 1197625000.22167.2.camel@neuromancer.home.net
Whole thread Raw
In response to Re: HouseKeeping and vacuum Questions  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-general
On Fri, 2007-12-14 at 09:35 +0100, Harald Armin Massa wrote:
> 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.

autovacuum is already turned on and the threshold is at default
settings.

Perhaps I need to tune it to be more aggressive? how can I do that?

delta between 2 vacuums in seconds or minutes? that would be nice.

pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: Re: HouseKeeping and vacuum Questions
Next
From: Ashish Karalkar
Date:
Subject: Planner ignoring to use INDEX SCAN