Mark Stosberg wrote:
> 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.
This has been tracked down to a bug in 8.1's Windows port. See
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-performance by date
|Next:||From: Albert Cervera Areny||Date: 2007-02-21 19:05:26|
|Subject: Re: General advice on user functions|
|Previous:||From: Mark Stosberg||Date: 2007-02-21 18:37:10|
|Subject: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?|