Re: autovacuum blues - Mailing list pgsql-general

From Richard Huxton
Subject Re: autovacuum blues
Date
Msg-id 45531250.3090802@archonet.com
Whole thread Raw
In response to autovacuum blues  ("Anton Melser" <melser.anton@gmail.com>)
Responses Re: autovacuum blues  ("Anton Melser" <melser.anton@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: RULE - special variables?
Next
From: Jorge Godoy
Date:
Subject: Re: Can PostgreSQL notify a client that a trigger has fired?