Re: Transaction Id Space, Freezing and Wraparound

2018-12-08 Thread Jeremy Schneider
On 11/20/18 13:00, Tom Lane wrote: > If the stored XIDs were 64 bits wide, we'd not have to bother with all > of this mess ... but adding another 64 bits to tuple headers would be > a painful space cost, not to mention the storage compatibility issues. People keep saying that. But didn't someone c

Re: Transaction Id Space, Freezing and Wraparound

2018-11-20 Thread Martín Fernández
Martín On Tue, Nov 20th, 2018 at 6:0 PM, Tom Lane wrote: > > > > =?UTF-8?q?Mart=C3=ADn_Fern=C3=A1ndez?= < fmarti...@gmail.com > writes: > > First thing that generated a lot of noise in my head was the following, > if pg assigns contiguous numeric values for the txid, how does pg deal > with f

Re: Transaction Id Space, Freezing and Wraparound

2018-11-20 Thread Tom Lane
=?UTF-8?q?Mart=C3=ADn_Fern=C3=A1ndez?= writes: > First thing that generated a lot of noise in my head was the following, if pg > assigns contiguous numeric values for the txid, how does pg deal with > fragmentation issues ? Then I later found that the txid space is actually > circular and not l