On Tue, Feb 7, 2012 at 2:27 PM, Ofer Israeli <of...@checkpoint.com> wrote:
> Thanks Kevin for the ideas.  Now that you have corrected our misconception 
> regarding the autovacuum not handling index bloating, we are looking into 
> running autovacuum frequently enough to make sure we don't have significant 
> increase in table size or index size.  We intend to keep our transactions 
> short enough not to reach the situation where vacuum full or CLUSTER is 
> needed.

Also, rather than going overboard with autovacuum settings, do make it
more aggressive, but also set up a regular, manual vacuum of either
the whole database or whatever tables you need to vacuum at
known-low-load hours.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to