| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Anton Melser <melser(dot)anton(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: autovacuum blues |
| Date: | 2006-11-09 11:34:40 |
| Message-ID: | 45531250.3090802@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Oh, and you might want to upgrade to 8.1.5 when convenient - that
shouldn't affect this though.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Godoy | 2006-11-09 11:43:11 | Re: Can PostgreSQL notify a client that a trigger has fired? |
| Previous Message | Russell Smith | 2006-11-09 11:31:10 | Re: planer picks a bad plan (seq-scan instead of index) |