Request a Demo
Home   >   mailing lists

Re: Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT - Mailing list pgsql-hackers

From cca5507
Subject Re: Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT
Date
Msg-id tencent_D87842071E760BA15D8537B5922954326808@qq.com
Whole thread Raw
In response to Re: Fix logical decoding not track transaction duringSNAPBUILD_BUILDING_SNAPSHOT  (ocean_li_996 <ocean_li_996@163.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Boris Mironov
Date:
Subject: Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)
Next
From: Bertrand Drouvot
Date:
Subject: Re: Add os_page_num to pg_buffercache