Re: partial VACUUM FULL - Mailing list pgsql-general

From Bill Moran
Subject Re: partial VACUUM FULL
Date
Msg-id 4061CD83.3090303@potentialtech.com
Whole thread Raw
In response to Re: partial VACUUM FULL  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
scott.marlowe wrote:
> On Tue, 23 Mar 2004, Tom Lane wrote:
>
>>Bill Moran <wmoran@potentialtech.com> writes:
>>
>>>Was this true for some previous version?  I could have swore I read somewhere
>>>that vacuum_mem had to be set high enough or vacuum wouldn't be able to clean
>>>everything up (aside from anything locked in transactions).
>>
>>Nope, never been the case.
>>
>>>Is performance the only reason for increasing vacuum_mem?
>>
>>Yes
>
> Maybe Bill's thinking of the fsm settings and regular vacuums and the
> limitations on how many tuples can be reclaimed by regular vacuuming being
> tied to fsm settings?

It's very likely that's where my confusion stemmed from, Scott.

Thanks for the pointer, I think I can clear up _all_ of my misunderstandings
now.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com


pgsql-general by date:

Previous
From: Rich Hall
Date:
Subject: Stored Function EXCEPTION detection by Perl using DBI
Next
From: "Grace C. Unson"
Date:
Subject: Transaction Isolation Level