Re: partial VACUUM FULL - Mailing list pgsql-general

From scott.marlowe
Subject Re: partial VACUUM FULL
Date
Msg-id Pine.LNX.4.33.0403240828320.32275-100000@css120.ihs.com
Whole thread Raw
In response to Re: partial VACUUM FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: partial VACUUM FULL
List pgsql-general
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?



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: No pg_hba.conf entry for host localhost (was: Re:
Next
From: "Joshua D. Drake"
Date:
Subject: Re: ole db