Robert Creager wrote:
>For 8.03, pg_autovacuum is running. On 7.4.1, I set up a cron job to vacuum
>analyze every 5 minutes.
Are you sure that pg_autovacuum is doing it's job? Meaning are you sure
it's vacuuming as often as needed? Try to run it with -d2 or so and
make sure that it is actually doing the vacuuming needed.
In response to
pgsql-performance by date
|Next:||From: Robert Creager||Date: 2005-07-18 04:10:50|
|Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS|
|Previous:||From: Robert Creager||Date: 2005-07-18 03:34:16|
|Subject: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?|