On Fri, Dec 17, 2004 at 18:53:42 -0800, Lonni J Friedman <[EMAIL PROTECTED]> wrote: > On Fri, 17 Dec 2004 15:28:30 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > On Fri, Dec 17, 2004 at 12:50:42 -0800, > > Lonni J Friedman <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly