Re: broken reading on standby (PostgreSQL 16.2)

From: "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: broken reading on standby (PostgreSQL 16.2)
Date: 2024-04-25 08:51:59
Message-ID: D7D1B167-F0A8-4FE2-9488-FA78621C7572@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 25 Apr 2024, at 12:06, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
> Unfortunately, I have not direct access to backup, so I am not able to test it. But VACUUM FREEZE DISABLE_PAGE_SKIPPING on master didn't help
>

If Primary considers all freezable tuples frozen, but a standby does not, "disable page skipping" won't change anything. Primary will not emit WAL record to freeze tuples again.

Best regards, Andrey Borodin.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2024-04-25 08:58:40 Improving the latch handling between logical replication launcher and worker processes.
Previous Message Yugo NAGATA 2024-04-25 08:41:55 Re: Remove unnecessary code rom be_lo_put()