On Mon, 2010-01-04 at 22:00 -0700, Benjamin Krajmalnik wrote:
> Alvaro, Scott - thanks for your replies and the direction you pointed me
> into.
>
> The underlying problem was that the cost limit was too low, so the
> autovacuum process would run forever and not be able to do anything. I
> reduce
Alvaro, Scott - thanks for your replies and the direction you pointed me
into.
The underlying problem was that the cost limit was too low, so the
autovacuum process would run forever and not be able to do anything. I
reduced the cost delay and increased the cost limit form the default of
200 to 1
0 8:40 PM
> To: Scott Marlowe
> Cc: Benjamin Krajmalnik; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Finetuning Autovacuum
>
> Scott Marlowe escribió:
> > On Mon, Jan 4, 2010 at 6:38 PM, Benjamin Krajmalnik
> wrote:
>
> > > Initially, I had scheduled tas
Scott Marlowe escribió:
> On Mon, Jan 4, 2010 at 6:38 PM, Benjamin Krajmalnik wrote:
> > 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
On Mon, Jan 4, 2010 at 7:10 PM, Benjamin Krajmalnik wrote:
> Thanks, Scott.
> I would think that we would reach some sort of steady state, yet the tables
> appear to continue to grow.
Then it's likely you're blowing out your free space map.
> Looking at the running processes from the server sta
ows; 9832 rows in sample, 48155 estimated total rowsTotal query runtime:
6937 ms.
Any suggestions on how to better tune autovacuum, or alternatively do you
recommend just running a vacuum analyze as a pgagent scheduled task?
> -Original Message-
> From: Scott Marlowe [mailto:scott
On Mon, Jan 4, 2010 at 6:38 PM, Benjamin Krajmalnik wrote:
> 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).
That's quite a lot. Even if you do get autovac / vacuum aggressive
enough, you
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 d
