Re: Some Autovacuum Questions - Mailing list pgsql-general

From Decibel!
Subject Re: Some Autovacuum Questions
Date
Msg-id F59A5379-C678-4454-858B-CAD81682EB9E@decibel.org
Whole thread Raw
In response to Some Autovacuum Questions  ("Thomas Chille" <thomas@chille.de>)
List 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@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Attachment

pgsql-general by date:

Previous
From: "Dan Armbrust"
Date:
Subject: performance issues on windows with 8.3.0?
Next
From: "Emil J."
Date:
Subject: pg_dump, pg_restore.