From: Mark Stosberg <mark@summersault.com>
To: pgsql-performance@postgresql.org
Subject: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
Date: Wed, 21 Feb 2007 13:37:10 -0500
Message-ID: <eri3hk$2dss$1@news.hub.org> (raw)
When I upgraded a busy database system to PostgreSQL 8.1, I was excited
about AutoVacuum, and promptly enabled it, and turned off the daily
vacuum process.
(
I set the following, as well as the option to enable auto vacuuming
stats_start_collector = true
stats_row_level = true
)
I could see in the logs that related activity was happening, but within
a few days, the performance became horrible, and enabling the regular
vacuum fixed it.
Eventually autovacuum was completely disabled.
What could have happened? Is 8.2 more likely to "just work" in the
regard? Is the the table-specific tuning that I would have needed to do?
I realize getting autovacuuming to work could be one way to exclude the
large table I wrote about in a recent post.
Mark
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: mark@summersault.com
Subject: Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
In-Reply-To: <eri3hk$2dss$1@news.hub.org>
* 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