Re: Usage of epoch in txid_current

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
Subject: Re: Usage of epoch in txid_current
Date: 2019-07-01 23:33:51
Message-ID: CA+hUKG+a21Ap_PmfHbh8_GTbsKmHpVPh7JfwaXzXcBZyDA=cMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jun 22, 2019 at 11:01 AM Alexander Korotkov
<a(dot)korotkov(at)postgrespro(dot)ru> wrote:
> 3. Change SLRU on-disk format to handle 64-bit xids and multixacts.
> In particular make SLRU page numbers 64-bit too. Add SLRU upgrade
> procedure to pg_upgrade.

+1 for doing this for the xid-indexed SLRUs so the segment file names
are never recycled. Having yet another level of wraparound code to
feed and water and debug is not nice:

https://www.postgresql.org/message-id/flat/20190202083822.GC32531%40gust.leadboat.com

--
Thomas Munro
https://enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2019-07-01 23:57:03 Re: Usage of epoch in txid_current
Previous Message Andres Freund 2019-07-01 23:32:15 Re: Increasing default value for effective_io_concurrency?