From: Matthew T. O'Connor <matthew@zeut.net>
To: Robert Creager <Robert_Creager@LogicalChaos.org>
Cc: PGPerformance <pgsql-performance@postgresql.org>
Cc: Andy Hewitt <Andy_Hewitt@StorageTek.com>
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 -
Date: Sun, 17 Jul 2005 23:48:20 -0400
Message-ID: <42DB2684.9020706@zeut.net> (raw)
In-Reply-To: <20050717213416.59dcb52e@thunder.logicalchaos.org>
References: <20050717213416.59dcb52e@thunder.logicalchaos.org>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matthew@zeut.net, Robert_Creager@LogicalChaos.org, Andy_Hewitt@StorageTek.com
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 -
In-Reply-To: <42DB2684.9020706@zeut.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox