Re: Vaccum Stalling

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Vaccum Stalling
Date: 2007-07-10 15:22:46
Message-ID: 1184080966.5455.7.camel@bnicholson-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-07-10 15:31:44 Re: Vaccum Stalling
Previous Message Tom Lane 2007-07-10 15:19:11 Re: Vaccum Stalling