Re: POC and rebased patch for CSN based snapshots - Mailing list pgsql-hackers

From Andrey V. Lepikhov
Subject Re: POC and rebased patch for CSN based snapshots
Date
Msg-id ffeb5718-e5da-651b-5778-09d68d685953@postgrespro.ru
Whole thread Raw
In response to Re: POC and rebased patch for CSN based snapshots  ("movead.li@highgo.ca" <movead.li@highgo.ca>)
List pgsql-hackers
On 7/4/20 7:56 PM, movead.li@highgo.ca wrote:
> 
> 
>     As far as I know about Clock-SI, left part of the blue line will
>     setup as a snapshot
> 
>     if master require a snapshot at time t1. But in fact data A should
>     in snapshot but
> 
>     not and data B should out of snapshot but not.
> 
> 
>     If this scene may appear in your origin patch? Or something my
>     understand about
> 
>     Clock-SI is wrong?
> 
> 
> 

Sorry for late answer.

I have doubts that I fully understood your question, but still.
What real problems do you see here? Transaction t1 doesn't get state of 
shard2 until time at node with shard2 won't reach start time of t1.
If transaction, that inserted B wants to know about it position in time 
relatively to t1 it will generate CSN, attach to node1 and will see, 
that t1 is not started yet.

Maybe you are saying about the case that someone who has a faster data 
channel can use the knowledge from node1 to change the state at node2?
If so, i think it is not a problem, or you can explain your idea.

-- 
regards,
Andrey Lepikhov
Postgres Professional



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Creating a function for exposing memory usage of backend process
Next
From: Ashutosh Bapat
Date:
Subject: Re: Bug with indexes on whole-row expressions