Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?
Дата
Msg-id 0ebcc8ea-7f5a-d014-d53f-e078622be35d@aklaver.com
обсуждение исходный текст
Ответ на Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?  (Rihad <grihad@gmail.com>)
Ответы Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?
Список pgsql-general
Дерево обсуждения 
On 8/21/23 09:31, Rihad wrote:
> On 8/21/23 20:17, Adrian Klaver wrote:
>> On 8/21/23 09:09, Rihad wrote:
>>> On 8/21/23 20:00, Adrian Klaver wrote:
>>

> 
> Sorry, they are all as per default, commented out in the config.
> 
> There are no long running queries, otherwise they wouldn't be 
> vacuumed/analyzed in due time after running first manual analyze, which 
> updates n_live_tup to match reltuples.
> 

My only remaining suggestion is to closely monitor the Postgres log and 
see if provides a clue.

-- 
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: The same prepared query yield "-1" the first six times and then "-1.0"
Следующее
От: Edoardo Panfili
Дата:
Сообщение: Re: The same prepared query yield "-1" the first six times and then "-1.0"