From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ofer Israeli <oferi@checkpoint.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Netta Kabala <nettak@checkpoint.com>
Cc: Olga Vingurt <olgavi@checkpoint.com>
Subject: Re: Vacuuming problems on TOAST table
Date: Wed, 08 Feb 2012 14:44:04 -0500
Message-ID: <29376.1328730244@sss.pgh.pa.us> (raw)
In-Reply-To: <217DDBC2BB1E394CA9E7446337CBDEF20102C056BFBE@il-ex01.ad.checkpoint.com>
References: <217DDBC2BB1E394CA9E7446337CBDEF20102C056BFBE@il-ex01.ad.checkpoint.com>
Ofer Israeli <oferi@checkpoint.com> writes:
> During our testing we see that the table size increases substantially. When looking at the autovacuum log, set with default configuration, it seems that it ran for around 60 seconds (see below and note that this was a 1-minute test, i.e. only 100 updates)!
autovacuum is intended to run fairly slowly, so as to not consume too
much resources. If you think it's too slow you can adjust the
autovacuum_cost tunables.
> When setting a higher cost for the autovacuum, tried values of 2000, it ran for even longer: ~400 seconds!
That's the wrong direction, no?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, oferi@checkpoint.com, nettak@checkpoint.com, olgavi@checkpoint.com
Subject: Re: Vacuuming problems on TOAST table
In-Reply-To: <29376.1328730244@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox