Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
От:
Сергей Шиндерук <s.shinderuk@postgrespro.ru>
Дата:
> 12 нояб. 2026 г., в 03:49, PG Bug reporting form написал(а):
>
> The following bug has been logged on the website:
>
> Bug reference: 19894
> Logged by: Sergey Shinderuk
> Email address: s.shinderuk@postgrespro.ru
> PostgreSQL version: 17.11
> Operating system: Ubuntu 24.04
> Description:
>
> Hello,
>
> after CREATE DATABASE on a primary
> select * from pg_visibility_map('pg_class')
> blkno | all_visible | all_frozen
> -------+-------------+------------
> 0 | t | t
> 1 | t | t
> 2 | t | t
> 3 | t | t
> 4 | t | t
> 5 | t | t
> 6 | t | t
> 7 | t | t
> 8 | t | t
> 9 | t | t
> 10 | t | t
> 11 | t | t
> 12 | t | t
> 13 | t | t
> (14 rows)
>
> but on a standby:
> blkno | all_visible | all_frozen
> -------+-------------+------------
> 0 | f | f
> 1 | f | f
> 2 | f | f
> 3 | f | f
> 4 | f | f
> 5 | f | f
> 6 | f | f
> 7 | f | f
> 8 | f | f
> 9 | f | f
> 10 | f | f
> 11 | f | f
> 12 | f | f
> 13 | f | f
> (14 rows)
Sorry, looks like it's a known issue:
https://www.postgresql.org/message-id/CAAKRu_bK7oJvtrrzL_V-OHouCWDKyU2-ERv+QvV6XM9Wh2dpUg@mail.gmail.com
https://www.postgresql.org/message-id/CAAKRu_aaP%3D0GZe%2BD721byOM9Vwjtu94VdAE_em0PNC0r3EK2zg%40mail.gmail.com
Didn't follow the discussion yet.