Skip site navigation (1) Skip section navigation (2)

Re: Inserts or Updates

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inserts or Updates
Date: 2012-02-07 17:31:20
Message-ID: CAGTBQpaR+_1MKOtSSSP+rg=OQLVHW26c1qSaVrvXpVR8TT4jGQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Feb 7, 2012 at 2:27 PM, Ofer Israeli <oferi(at)checkpoint(dot)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.

In response to

Responses

pgsql-performance by date

Next:From: Ofer IsraeliDate: 2012-02-07 17:40:11
Subject: Re: Inserts or Updates
Previous:From: Ofer IsraeliDate: 2012-02-07 17:27:33
Subject: Re: Inserts or Updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group