From: PFC <lists@peufeu.com>
To: Joost Kraaijeveld <J.Kraaijeveld@askesis.nl>
To: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: Vacuum takes forever
Date: Tue, 29 May 2007 19:16:41 +0200
Message-ID: <op.ts3l93nqcigqcu@apollo13> (raw)
In-Reply-To: <1180458223.18930.16.camel@panoramix>
References: <1180458223.18930.16.camel@panoramix>
> Could this be because of my Cost-Based Vacuum Delay settings ?
Yeah. It is supposed to slow down VACUUM so it doesn't kill your server,
but it is not aware of the load. It will also slow it down if there is no
load. That is its purpose after all ;)
If you want fast vacuum, issue SET vacuum_cost_delay = 0; before.
>
> vacuum_cost_delay = 200
> vacuum_cost_page_hit = 6
> #vacuum_cost_page_miss = 10 # 0-10000 credits
> #vacuum_cost_page_dirty = 20 # 0-10000 credits
> vacuum_cost_limit = 100
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@peufeu.com, J.Kraaijeveld@askesis.nl
Subject: Re: Vacuum takes forever
In-Reply-To: <op.ts3l93nqcigqcu@apollo13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox