Re: replacements for vacuum? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: replacements for vacuum?
Date
Msg-id 20041218044339.GB20619@wolff.to
Whole thread Raw
In response to Re: replacements for vacuum?  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
On Fri, Dec 17, 2004 at 18:53:42 -0800,
  Lonni J Friedman <netllama@gmail.com> wrote:
> On Fri, 17 Dec 2004 15:28:30 -0600, Bruno Wolff III <bruno@wolff.to> wrote:
> > On Fri, Dec 17, 2004 at 12:50:42 -0800,
> >   Lonni J Friedman <netllama@gmail.com> wrote:
> > > Greetings,
> > > Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
> >
> > What problem are you trying to solve?
>
> I'd like to be able to run vacuum in a 'test' or read-only mode where
> i'd see what it would do before actually running it.  I don't see any
> mention of any options to accomplish this in the vacuum man page.

That is because there isn't much point in doing all of that disk IO and
not actually freeing up the deleted tuples.

Unless you only want this out of curiosity, I don't think you have told
us what problem you are really trying to solve.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: unix_socket_directory
Next
From: Bruno Wolff III
Date:
Subject: Re: Contacting Tom Lane :)