Re: Detailed questions about pg_xact_commit_timestamp

2019-07-16 Thread Morris de Oryx
Adrien, thanks a lot for taking the time to try and explain all of these details to me. I'm looking at incremental rollups, and thinking through various alternative designs. It sounds like pg_xact_commit_timestamp just isn't the right tool for my purposes, so I'll go in another direction. All the

Re: Detailed questions about pg_xact_commit_timestamp

2019-07-16 Thread Adrien Nayrat
On 7/12/19 2:50 PM, Morris de Oryx wrote: > Adrien, thanks very much for answering my question. Just a couple of follow-up > points, if you don't mind. > > In our answer, you offer an example of pg_xact_commit_timestamp showing > out-of-sequence commit times: > > Session     xid          pg_xact_

Re: Detailed questions about pg_xact_commit_timestamp

2019-07-12 Thread Morris de Oryx
Adrien, thanks very much for answering my question. Just a couple of follow-up points, if you don't mind. In our answer, you offer an example of pg_xact_commit_timestamp showing out-of-sequence commit times: Session xid pg_xact_commit_timestamp A 34386826 2019-07-11 09:

Re: Detailed questions about pg_xact_commit_timestamp

2019-07-11 Thread Adrien Nayrat
Hi, On 7/9/19 12:22 AM, Morris de Oryx wrote: > I have some specific questions about pg_xact_commit_timestamp, and am hoping > that this is the right place to ask. I read a lot of the commentary about the > original patch, and the contributors seem to be here. If I'm asking in the > wrong > place

Detailed questions about pg_xact_commit_timestamp

2019-07-08 Thread Morris de Oryx
I have some specific questions about pg_xact_commit_timestamp, and am hoping that this is the right place to ask. I read a lot of the commentary about the original patch, and the contributors seem to be here. If I'm asking in the wrong place, just let me know. I'm working on a design for a concurr