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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rihad <grihad(at)gmail(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?
Date: 2023-08-21 16:50:06
Message-ID: 0ebcc8ea-7f5a-d014-d53f-e078622be35d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edoardo Panfili 2023-08-21 17:16:17 Re: The same prepared query yield "-1" the first six times and then "-1.0"
Previous Message Tom Lane 2023-08-21 16:45:48 Re: The same prepared query yield "-1" the first six times and then "-1.0"