Re: Some Autovacuum Questions

From: Decibel! <decibel(at)decibel(dot)org>
To: Thomas Chille <thomas(at)chille(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Some Autovacuum Questions
Date: 2008-02-14 01:56:04
Message-ID: F59A5379-C678-4454-858B-CAD81682EB9E@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 12, 2008, at 9:13 AM, Thomas Chille wrote:
> vacuum_cost_delay = 200
> vacuum_cost_page_hit = 6
> vacuum_cost_limit = 100

Vacuum is going to take forever with those settings. I strongly
suggest you set them back to default. If you need to throttle vacuum,
try setting cost_delay to between 10 and 20.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Armbrust 2008-02-14 02:06:55 performance issues on windows with 8.3.0?
Previous Message Ken Johanson 2008-02-13 22:43:20 Re: SELECT CAST(123 AS char) -> 1