Re: vacuum locking - Mailing list pgsql-performance

From Tom Lane
Subject Re: vacuum locking
Date
Msg-id 29064.1066915061@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum locking  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: vacuum locking
List pgsql-performance
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Wed, Oct 22, 2003 at 09:27:47PM -0400, Tom Lane wrote:
>> trace.  What is causing that?  Not VACUUM I don't think.  It doesn't have
>> any huge memory demand.  But swapping out processes could account for

> What about if you've set vacuum_mem too high?

Maybe, but only if it actually had reason to use a ton of memory ---
that is, it were recycling a very large number of tuples in a single
table.  IIRC that didn't seem to be the case here.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: vacuum locking
Next
From: Allen Landsidel
Date:
Subject: My own performance/tuning q&a