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