Postgres Pro
Downloads
Home   >   mailing lists

Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?
Date
Msg-id 0ebcc8ea-7f5a-d014-d53f-e078622be35d@aklaver.com
Whole thread Raw
In response to Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?  (Rihad <grihad@gmail.com>)
Responses Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?  (Rihad <grihad@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"
Next
From: Edoardo Panfili
Date:
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"