Re: [EXT] Sequence Cycle question - Mailing list pgsql-admin

From Scott Ribe
Subject Re: [EXT] Sequence Cycle question
Date
Msg-id 2D959E91-FF1C-4761-BA3E-B9EE09874244@elevated-dev.com
Whole thread Raw
In response to RE: [EXT] Re: Sequence Cycle question  ("Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>)
List pgsql-admin
> On Jan 23, 2025, at 12:37 PM, Wong, Kam Fook (TR Technology) <kamfook.wong@thomsonreuters.com> wrote:
>
> 1) Create a new column with bigint datatype (double the max limits of int).

Double the width, ~4,000,000,000 times max limit

> ...
> 5) Then this will buy you time to consider other design options for PK.

Like, until the sun burns out and engulfs the earth ;-)


--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/






pgsql-admin by date:

Previous
From: Mauricio Fernandez
Date:
Subject: Re: [EXT] Re: High Availability
Next
From: Rajesh Kumar
Date:
Subject: Re: Archiving solutions