Sequence Cycle question

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Sequence Cycle question
Date: 2025-01-23 17:13:05
Message-ID: SJ0PR11MB562940815F89B85D4FF64D25DEE02@SJ0PR11MB5629.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL 16

Question on how Cycle works with example:

I have table X with a primary key ID which is an integer that uses a sequence.

Sequence Settings:
start_value=1
min_value=1
max_value=1,000,000
cycle=true

Use Case:
Table X has records that have been removed over time randomly. There are IDs that cover a wide range of values between 1 and 1,000,000.

When the primary key ID, which is a sequence, reaches 1,000,000 then the next sequence value will start back at 1.

What would happen if I had a primary key for ID of 5 still in use? When I reach 5 will the sequence skip that number and go to 6 instead?

Could you please add some text in the documentation to explain this Use Case? It seems very important.

Thanks,

Lance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2025-01-23 17:41:40 Re: Sequence Cycle question
Previous Message Gabriel Guillem Barceló Soteras 2025-01-23 13:15:19 Re: High Availability