From: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
---|---|
To: | y(dot)sokolov(at)postgrespro(dot)ru |
Cc: | dilipbalaut(at)gmail(dot)com, rjuju123(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Error "initial slot snapshot too large" in create replication slot |
Date: | 2022-04-01 06:53:16 |
Message-ID: | 20220401.155316.930989254339879136.horikyota.ntt@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At Fri, 01 Apr 2022 14:44:30 +0900 (JST), Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> wrote in
> At Sun, 13 Feb 2022 17:35:38 +0300, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru> wrote in
> > And there are checks for `takenDuringRecovery` in `heapgetpage` and
> > `heapam_scan_sample_next_tuple`. Are this checks affected by the change?
> > Neither the preceding discussion nor commit message answer me.
>
> The snapshot works correctly, but for the heapgetpage case, it foces
> all_visible to be false. That unnecessarily prevents visibility check
> from skipping.
>
> An annoying thing in SnapBuildInitialSnapshot is that we don't know
> the number of xids before looping over the xid range, and we don't
> want to bother sorting top-level xids and subxids unless we have to do
> so.
>
> Is it better that we hassle in SnapBuildInitialSnapshot to create a
> !takenDuringRecovery snapshot?
So this is that. v5 creates a regular snapshot.
By the way, is there any chance this could be committed to 15?
Otherwise I'll immediately move this to the next CF.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
Attachment | Content-Type | Size |
---|---|---|
v5-0001-Create-correct-snapshot-during-CREATE_REPLICATION.patch | text/x-patch | 5.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2022-04-01 06:58:13 | Re: generic plans and "initial" pruning |
Previous Message | Julien Rouhaud | 2022-04-01 06:19:46 | Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work. |