Hi Anton! I'm not sure how this is with 8.1 but on 7.4.14 we have to enable row level statistics collection for autovacuum: stats_row_level = true Greetings, Matthias > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Anton Melser > Sent: Thursday, November 09, 2006 1:12 PM > To: Richard Huxton > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] autovacuum blues > postgres 1300 0.0 1.1 20180 3048 ? S 12:03 0:00 > /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data > postgres 1302 0.0 0.2 9968 544 ? S 12:03 0:00 > postgres: logger process > postgres 1304 0.0 0.4 20316 1188 ? S 12:03 0:00 > postgres: writer process > postgres 1305 0.0 0.6 10968 1544 ? S 12:03 0:00 > postgres: stats buffer process > postgres 1306 0.0 0.3 10200 796 ? S 12:03 0:00 > postgres: stats collector process > ... > Any chance you could give me some pointers on activating logging? My > thoughts were to log > log_planner_stats = on > log_min_messages = info >
