Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum analyze in 7.1.1 - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Vacuum analyze in 7.1.1
Date
Msg-id Pine.LNX.4.30.0106132237130.756-100000@peter.localdomain
Whole thread Raw
In response to Vacuum analyze in 7.1.1  ("David Wall" <d.wall@computer.org>)
List pgsql-general
Tree view 
David Wall writes:

> Does a 'vacuum analyze' do the same functions as a plain 'vacuum' PLUS the stats updates?  Just wondering if I need
torun both commands from time to time, or if I can just do 'vacuum analyze'?  I'm running 7.1.1 now. 

yes / no / yes

However, depending on your application you might want to run 'vacuum' more
often than 'vacuum analyze'.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Log files, how to rotate properly
Next
From: Lamar Owen
Date:
Subject: Re: Log files, how to rotate properly