Horton

Re: AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

View thread
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Hans Buschmann <buschmann@nidsa.net>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2023-05-23T16:18:55Z
Lists: pgsql-bugs 
On 22.05.23 09:11, Hans Buschmann wrote:
> But I wonder, why this test is necessary at every autovacuum call at all?
> 
> Woudn't it be sufficient to test it at server start time only once?

The main server process (postmaster) cannot access the database 
contents.  So we can only do it when we start a session process.