Re: Wraparound

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>, Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Wraparound
Date: 2024-02-22 06:52:15
Message-ID: bc00d586eb0171b4e99c13058ff3ed77fa578ff5.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2024-02-22 at 10:16 +0530, Rajesh Kumar wrote:
> So, is there a way to change to 64bit?

https://www.postgresql.org/search/?m=1&q=64-bit+xid&l=1&d=-1&s=r

- it is appealing

- it would break "pg_upgrade"

- it would inflate each table row by 8 bytes

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fabrice Chapuis 2024-02-22 08:05:22 Re: pg_restore option --clean
Previous Message Rajesh Kumar 2024-02-22 04:46:23 Re: Wraparound