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

Re: autovacuum: recommended?

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: tv(at)fuzzy(dot)cz
Cc: Tobias Brox <tobias(at)nordicbet(dot)com>, Gábor Farkas <gabor(at)nekomancer(dot)net>,pgsql-performance(at)postgresql(dot)org
Subject: Re: autovacuum: recommended?
Date: 2007-11-18 19:00:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
> 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 ;-)

In response to

pgsql-performance by date

Next:From: gaborDate: 2007-11-18 19:26:12
Subject: Re: autovacuum: recommended?
Previous:From: Tom LaneDate: 2007-11-18 18:28:39
Subject: Re: Performance problem (outer join + view + non-strict functions)‏

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