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