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

Finetuning Autovacuum

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Finetuning Autovacuum
Date: 2010-01-05 01:38:13
Message-ID: F4E6A2751A2823418A21D4A160B68988613C60@fletch.stackdump.local (view raw or flat)
Thread:
Lists: pgsql-admin
PostgreSQL 8.4/FreeBSD 7.2 amd64

 

I have a database which has  3 tables which get a very high level of
activity (about 40 thousand updates per minute).

The tables are getting quite bloated, since autovacuum is apparently not
optimally configured (it is using the default settings).

Anything I do must be such that it will not cause deadlocks, since the
effects can be catastrophic with the amount of data being pumped through
the system.

 

Initially, I had scheduled tasks through pgagent running a vacuum
analyze every 15 minutes, but other posts I have read here have stated
this could cause deadlocks, and mentioned running autovacuum is
preferable

.

Also, are rows "vacuumed" in the indices made available without having
to reindex?  The reason I am asking is because the indices seem to be
bloating to a much higher factor than the data table.

 

Thanks in advance

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2010-01-05 01:49:41
Subject: Re: Finetuning Autovacuum
Previous:From: Renato OliveiraDate: 2010-01-04 13:19:57
Subject: Re: How can i change the Postgres Database password?

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