Re: partial VACUUM FULL

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bill Moran <wmoran(at)potentialtech(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: partial VACUUM FULL
Date: 2004-03-24 15:30:51
Message-ID: Pine.LNX.4.33.0403240828320.32275-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 23 Mar 2004, Tom Lane wrote:

> Bill Moran <wmoran(at)potentialtech(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-03-24 16:28:53 Re: ole db
Previous Message Frank Wiles 2004-03-24 15:29:09 Re: subversion vs cvs (Was: Re: linked list rewrite)