Re: Sequence gaps after restart - Mailing list pgsql-general

Christopher Sumner <christopher.sumner@adimab.com> writes:
> I'm using PostgreSQL v. 10.14 via AWS Aurora Serverless.  Our users
> recently noticed gaps in the primary ids for many of our tables.  As I
> understand it, this is due to PostgreSQL effectively caching 32 additional
> sequence values (hardcoded in sequence.c ) and a 'restart' occurs.

Well, 32 is the worst case, but yes this is behaving as intended.

> Are there any plans to fix this issue

No.  If you must have gapless values, don't use sequences.

            regards, tom lane