Re: autovacuum blues

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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Anton Melser
> Sent: Thursday, November 09, 2006 1:12 PM
> To: Richard Huxton
> Cc: pgsql-general(at)postgresql(dot)org
> 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
>