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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
