pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / 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>
  2005-04-18 19:58 ` Re: Question on vacuumdb Bruno Wolff III <bruno@wolff.to>
  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:27 Question on vacuumdb Bill Chandler <billybobc1210@yahoo.com>
@ 2005-04-18 19:58 ` Bruno Wolff III <bruno@wolff.to>
  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