64 bit TID?

Поиск
Список
Период
Сортировка
От Chris Cleveland
Тема 64 bit TID?
Дата
Msg-id CABSN6VdevsZayUcEV_RaQ6SMjDuSvKRiKAQjYCaskL9z+wFxng@mail.gmail.com
обсуждение исходный текст
Ответы Re: 64 bit TID?  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Список pgsql-hackers
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 needs a TID, and something like an IoT app is updating huge numbers of rows per second using multiple connections in parallel, there might be a problem. This is especially true if each connection requests a batch of TIDs and then doesn't use all of them.

Are there any plans in the works to widen the TID?

I saw some notes on this in the Zedstore project, but there hasn't been much activity in that project for almost a year.

Chris

--
Chris Cleveland
312-339-2677 mobile

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Skipping logical replication transactions on subscriber side
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Estimating HugePages Requirements?