Re: Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT

From: cca5507 <cca5507(at)qq(dot)com>
To: ocean_li_996 <ocean_li_996(at)163(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT
Date: 2025-11-23 08:15:35
Message-ID: tencent_D87842071E760BA15D8537B5922954326808@qq.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Haiyang,

> v6-0004 only skip the transaction commited during START state and precedeing next_phase_at
> (set when changing to BUILDING_SNAPSHOT state) during BUILDING_SNAPSHOT. Those transactions
> are always useless no matter in fast forward or not. Plaese recheck v6-0004 again.

Yeah, you're right. What's useful for building the snapshot and we currently don't track are the txns
start after BUILDING_SNAPSHOT and commit before FULL_SNAPSHOT, their xids all >= next_phase_at
during BUILDING_SNAPSHOT.

--
Regards,
ChangAo Chen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2025-11-23 09:15:31 Re: Add os_page_num to pg_buffercache
Previous Message Boris Mironov 2025-11-23 07:51:30 Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)