On Mon, Apr 18, 2005 at 12:27:08 -0700, Bill Chandler <[EMAIL PROTECTED]> wrote: > All, > > If I run the command "vacuumdb mydb" I understand that > it does some disk space recovery (but not as much as > "vacuumdb --full mydb").
You are better off not using vacuum full unless some unusual event has bloated your database. By running normal vacuums often enough (and with a large enough fsm setting) your database should reach a steady state size. > Question: if I run the command "vacuumdb --analyze > mydb" does it still do the aforementioned disk space > recovery AS WELL AS update query planning statistics? > Or are those two completely separate operations > requiring separate invocations of 'vacuumdb'. It is better to do both with one command. ---------------------------(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