Horton

Re: vacuum full

scott.marlowe <scott.marlowe@ihs.com>

View thread
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Henrik Steffen <steffen@city-map.de>
Cc: <pgsql-performance@postgresql.org>
Date: 2002-11-21T17:32:44Z
Lists: pgsql-performance 
On Thu, 21 Nov 2002, Henrik Steffen wrote:

> 
> hello all,
> 
> how often should "vacuum full" usually be run ?

I recommend nightly.  Also, check index size.  If they are growing, you 
may want to reindex each night or week as well.