Re: [EXT] Sequence Cycle question

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: [EXT] Sequence Cycle question
Date: 2025-01-23 20:22:10
Message-ID: 2D959E91-FF1C-4761-BA3E-B9EE09874244@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jan 23, 2025, at 12:37 PM, Wong, Kam Fook (TR Technology) <kamfook(dot)wong(at)thomsonreuters(dot)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(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2025-01-24 03:36:13 Re: Archiving solutions
Previous Message Mauricio Fernandez 2025-01-23 19:59:27 Re: [EXT] Re: High Availability