Re: Transaction Id Space, Freezing and Wraparound

Поиск
Список
Период
Сортировка
От Jeremy Schneider
Тема Re: Transaction Id Space, Freezing and Wraparound
Дата
Msg-id fc177d37-878c-6a3b-bd7a-6e8e753681b8@ardentperf.com
обсуждение исходный текст
Ответ на Re: Transaction Id Space, Freezing and Wraparound  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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 come up with a way to do
this by storing the top 32 bits just once somewhere in the block, rather
than adding 64 bits to every tuple? I can't remember if there was an
email thread.

Maybe some other drawbacks to that approach, but lets at least point out
adding 64 bits to the tuple header isn't the only way to accomplish this.

And the other thread about memory management... if I'm going to start
religious wars, might as well just start them all at once right?  ;)

-J

-- 
http://about.me/jeremy_schneider


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: amazon aroura config - seriously overcommited defaults? (May beOff Topic)
Следующее
От: Mike Lissner
Дата:
Сообщение: Errors with schema migration and logical replication — expected?