pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs
2+ messages / 2 participants
[nested] [flat]

* AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs
@ 2023-05-22 07:11  Hans Buschmann <buschmann@nidsa.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Hans Buschmann @ 2023-05-22 07:11 UTC (permalink / raw)
  To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

+1 for disabling the warnings there!


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?


Are there perhaps other places with this test?


Hans Buschmann


________________________________

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs
@ 2023-05-23 16:18  Peter Eisentraut <peter.eisentraut@enterprisedb.com>
  parent: Hans Buschmann <buschmann@nidsa.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2023-05-23 16:18 UTC (permalink / raw)
  To: Hans Buschmann <buschmann@nidsa.net>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

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.






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-05-23 16:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-22 07:11 AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs Hans Buschmann <buschmann@nidsa.net>
2023-05-23 16:18 ` Peter Eisentraut <peter.eisentraut@enterprisedb.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox