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
http://people.planetpostgresql.org/mha/index.php?/archives/134-8.1-on-win32-pgstat-and-autovacuum.html
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support