Christopher Sumner <christopher.sum...@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
