transaction wraparound

From: Павел Ерёмин <shnoor111gmail(at)yandex(dot)ru>
To: pgsql-novice(at)postgresql(dot)org
Subject: transaction wraparound
Date: 2019-10-31 07:15:45
Message-ID: 21380461572506145@myt4-d6710af5e038.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<div><div>Hi.</div><div>I apologize for my English.</div><div>I have a question about transaction wraparound. As far as I know, transaction numbers are 32 bit, which greatly limits their number. In the tuple header there are now  t_xmin and  t_xmax fields - both 32 bits each. So why not replace them with a single field with a transaction number of 64 bits length - this is the transaction number that created the version ( this is exactly what the MS SQL server does)? In this case, you do not have to lengthen header tuple. Of course, this can result in increased I/O, so to compensate for it, you can turn off buffered read (O_DIRECT) while reading.</div></div>

Attachment Content-Type Size
unknown_filename text/html 671 bytes

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2019-10-31 10:14:06 Re: transaction wraparound
Previous Message Laurenz Albe 2019-10-30 17:54:19 Re: Adding primary key on table with 3 billion records.