Re: 64 bit TID?

2021-09-13 Thread Peter Geoghegan
On Mon, Sep 13, 2021 at 5:36 PM Peter Geoghegan wrote: > If somebody wants to make TIDs (or some generalized TID-like thing > that tableam knows about) into logical identifiers, then they must > also answer the question: identifiers of what? > > TIDs from Postgres heapam identify a physical

Re: 64 bit TID?

2021-09-13 Thread Peter Geoghegan
On Mon, Sep 13, 2021 at 3:30 PM Chris Cleveland wrote: > Wow, thank you, that is some thread. It discusses the issues > thoroughly. If somebody wants to make TIDs (or some generalized TID-like thing that tableam knows about) into logical identifiers, then they must also answer the question:

Re: 64 bit TID?

2021-09-13 Thread Chris Cleveland
> > Are there any plans in the works to widen the TID? > > This was recently discussed here [0] as well, but to the best of my > knowledge no material proposal to update the APIs has been suggested > as of yet. > > [0] >

Re: 64 bit TID?

2021-09-13 Thread Matthias van de Meent
On Mon, 13 Sept 2021 at 17:50, Chris Cleveland wrote: > > All, > > I'm considering a new design for a specialized table am. It would simplify > the design if TIDs grew forever and I didn't have to implement TID reuse > logic. TID reuse logic also helps clean up index tuples for deleted table

64 bit TID?

2021-09-13 Thread Chris Cleveland
All, I'm considering a new design for a specialized table am. It would simplify the design if TIDs grew forever and I didn't have to implement TID reuse logic. The current 48 bit TID is big, but I can see extreme situations where it might not be quite big enough. If every row that gets updated