Alvaro Herrera wrote: > 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 Thanks for the response Alvaro. This would have been on FreeBSD. Let me ask the question a different way: Is simply setting the two values plus enabling autovacuuming generally enough, or is further tweaking common place? Perhaps I'll give it another tree when we upgrade to 8.2. Mark
