pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Question on vacuumdb 2+ messages / 2 participants [nested] [flat]
* Question on vacuumdb @ 2005-04-18 19:27 Bill Chandler <billybobc1210@yahoo.com> 0 siblings, 1 reply; 2+ messages in thread From: Bill Chandler @ 2005-04-18 19:27 UTC (permalink / raw) To: pgsql-performance 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"). 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'. thanks, Bill __________________________________ Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! http://travel.yahoo.com/p-travelguide ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Question on vacuumdb @ 2005-04-18 19:58 Bruno Wolff III <bruno@wolff.to> parent: Bill Chandler <billybobc1210@yahoo.com> 0 siblings, 0 replies; 2+ messages in thread From: Bruno Wolff III @ 2005-04-18 19:58 UTC (permalink / raw) To: Bill Chandler <billybobc1210@yahoo.com>; +Cc: pgsql-performance On Mon, Apr 18, 2005 at 12:27:08 -0700, Bill Chandler <billybobc1210@yahoo.com> 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-18 19:58 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-04-18 19:27 Question on vacuumdb Bill Chandler <billybobc1210@yahoo.com> 2005-04-18 19:58 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox