Skip site navigation (1) Skip section navigation (2)

Re: Vacuum takes forever

From: PFC <lists(at)peufeu(dot)com>
To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)askesis(dot)nl>, "postgresql performance list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Vacuum takes forever
Date: 2007-05-29 17:16:41
Message-ID: op.ts3l93nqcigqcu@apollo13 (view raw or flat)
Thread:
Lists: pgsql-performance

> 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
>
>
>



In response to

Responses

pgsql-performance by date

Next:From: Joost KraaijeveldDate: 2007-05-29 17:56:07
Subject: Re: Vacuum takes forever
Previous:From: Joost KraaijeveldDate: 2007-05-29 17:03:43
Subject: Vacuum takes forever

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group