Re: replacements for vacuum?

On Fri, Dec 17, 2004 at 18:53:42 -0800,
Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
> On Fri, 17 Dec 2004 15:28:30 -0600, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> > On Fri, Dec 17, 2004 at 12:50:42 -0800,
> > Lonni J Friedman <netllama(at)gmail(dot)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.