Sequence Cycle question

["Campbell, Lance" <lance@xxxxxxxxxxxx>]

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