Re: Vaccum Stalling - Mailing list pgsql-general

From Brad Nicholson
Subject Re: Vaccum Stalling
Date
Msg-id 1184080966.5455.7.camel@bnicholson-desktop
Whole thread Raw
In response to Vaccum Stalling  (Brad Nicholson <bnichols@ca.afilias.info>)
Responses Re: Vaccum Stalling
List pgsql-general
On Tue, 2007-07-10 at 11:19 -0400, Tom Lane wrote:
> Oh, I forgot to mention --- you did check that vacuum_mem is set to
> a pretty high value, no?  Else you might be doing a lot more
> btbulkdelete scans than you need to.
>
>             regards, tom lane

What would you define as high for 7.4?  I bumped it up to ~ 245mbs

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vaccum Stalling
Next
From: Tom Lane
Date:
Subject: Re: Vaccum Stalling