Re: autovacuum blues

On 09/11/06, Richard Huxton <dev(at)archonet(dot)com> wrote:
> Anton Melser wrote:
> > Hi,
> > I just can't understand why autovacuum is not working. I have a test
> > db/table which I insert values into (by the thousands) and can't work
> > out why my stats don't get updated. Could someone have a quick look at
> > my attached .conf and tell me what I am doing?
> > I am running it on FC5 8.1.4.fc5.1.
>
> 1. Check "ps auxw | grep postgres" to see if it's running.
> 2. If so, check your PG logs and see if you see any activity. Turn
> connection and statement logging on and see what appears.
>

...
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

Anything else?
Cheers
Antoine