Re: autovacuum blues

On 09/11/06, Richard Huxton <dev@archonet.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