From: Tobias Brox <tobias@nordicbet.com>
To: tv@fuzzy.cz
Cc: Tobias Brox <tobias@nordicbet.com>
Cc: Gábor Farkas <gabor@nekomancer.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum: recommended?
Date: Sun, 18 Nov 2007 20:00:53 +0100
Message-ID: <20071118190053.GN1195@mail.nordicbet.com> (raw)
In-Reply-To: <61575.212.24.144.68.1195220303.squirrel@mail.fuzzy.cz>
References: <473D659B.1070008@nekomancer.net>
<20071116111355.GB1195@mail.nordicbet.com>
<61575.212.24.144.68.1195220303.squirrel@mail.fuzzy.cz>
[tv@fuzzy.cz]
> The table was quite huge (say 20k of products along with detailed
> descriptions etc.) and was completely updated and about 12x each day, i.e.
> it qrew to about 12x the original size (and 11/12 of the rows were dead).
> This caused a serious slowdown of the application each day, as the
> database had to scan 12x more data.
The tables we had problems with are transaction-type tables with
millions of rows and mostly inserts to the table ... and, eventually
some few attributes being updated only on the most recent entries. I
tried tuning a lot, but gave it up eventually. Vacuuming those tables
took a long time (even if only a very small fraction of the table was
touched) and the performance of the inserts to the table was reduced to
a level that could not be accepted.
By now we've just upgraded the hardware, so it could be worth playing
with it again, but our project manager is both paranoid and conservative
and proud of it, so I would have to prove that autovacuum is good for us
before I'm allowed to turn it on again ;-)
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: tobias@nordicbet.com, tv@fuzzy.cz, gabor@nekomancer.net
Subject: Re: autovacuum: recommended?
In-Reply-To: <20071118190053.GN1195@mail.nordicbet.com>
* 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