Re: autovacuum?

Поиск
Список
Период
Сортировка
От Jan Danielsson
Тема Re: autovacuum?
Дата
Msg-id 453004B9.5070008@gmail.com
обсуждение исходный текст
Ответ на Re: autovacuum?  (Shane Ambler <pgsql@007Marketing.com>)
Список pgsql-novice
Shane Ambler wrote:
[---]
>>    Ok, I finally found the relevant documentation. Seems I had to enable
>> two other keywords in the postgresql.conf file. However, I still haven't
>> figured out how I can actually verify that it *is* running the vacuum
>> procedure. Any hints?
>>
>>
> I'm not sure if there is a way.
>
> I would think detailed enough logs should show it up but that may have
> to be at debug level I am guessing.
>
> The only one I would think of is to check the stats - I would use
> pgAdmin and check the row counts on a table (these show up after a
> vacuum) before and after you know a number of rows have been inserted
> and see if that updates after a couple of minutes.

   Thanks for the tips. I'll try to crank up the level of logging a
notch and see, and I'll also take a look at pgAdmin.

--
Kind Regards,
Jan Danielsson
Te audire non possum. Musa sapientum fixa est in aure.


Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: autovacuum?
Следующее
От: "Keith Worthington"
Дата:
Сообщение: Range