Re: Vacuum looping? - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Vacuum looping?
Date
Msg-id 20070728163624.GI39272@nasby.net
Whole thread Raw
In response to Vacuum looping?  ("Steven Flatt" <steven.flatt@gmail.com>)
Responses Re: Vacuum looping?  ("Steven Flatt" <steven.flatt@gmail.com>)
List pgsql-performance
On Fri, Jul 27, 2007 at 05:32:11PM -0400, Steven Flatt wrote:
> weren't convinced was doing anything), then start a manual vacuum with a
> higher vacuum_cost_limit to get things cleaned up quicker.

What are your vacuum_cost_* settings? If you set those too aggressively
you'll be in big trouble.

The second pass on the vacuum means that maintenance_work_memory isn't
large enough.
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum looping?
Next
From: andrew@pillette.com
Date:
Subject: Re: Slow query with backwards index scan