Re: autovacuum blues

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: autovacuum blues
Дата
Msg-id 45531250.3090802@archonet.com
обсуждение исходный текст
Ответ на autovacuum blues  ("Anton Melser" <melser.anton@gmail.com>)
Ответы Re: autovacuum blues
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: RULE - special variables?
Следующее
От: Jorge Godoy
Дата:
Сообщение: Re: Can PostgreSQL notify a client that a trigger has fired?