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

Re: [PERFORM] autovacuum on a -mostly- r/o table

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: Edoardo Ceccarelli <eddy(at)axa(dot)it>
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
Date: 2006-09-27 16:13:29
Message-ID: 20060927161329.GB25630@oppetid.no (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
[Edoardo Ceccarelli - Wed at 06:08:30PM +0200]
> We also activated the autovacuum feature to give it a try and that's 
> were our problems started.
(...)
> How can I configure the vacuum to run after the daily batch insert/update?

I think you shouldn't use autovacuum in your case.

We haven't dared testing out autovacuum yet even though we probably
should, so we're running vacuum at fixed times of the day.  We have a
very simple script to do this, the most important part of it reads:

echo "vacuum verbose analyze;" | psql $DB_NAME > $logdir/$filename 2>&1


In response to

pgsql-performance by date

Next:From: Csaba NagyDate: 2006-09-27 16:13:44
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
Previous:From: Alan HodgsonDate: 2006-09-27 16:13:22
Subject: Re: autovacuum on a -mostly- r/o table

pgsql-admin by date

Next:From: Csaba NagyDate: 2006-09-27 16:13:44
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
Previous:From: Alan HodgsonDate: 2006-09-27 16:13:22
Subject: Re: autovacuum on a -mostly- r/o table

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