On 5/11/21 9:54 AM, Christopher Sumner wrote:
Hello.

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.  Losing a few sequence values is normal and generally acceptable.  However, this problem seems to be exacerbated by the scaling events of Aurora Serverless as they require restarts of the Postgresql service. I do not allow AWS AS to force the scaling in our environment. When scaling events happen 10's of times per day, the loss is significant.

Are there any plans to fix this issue or otherwise play nicely with Aurora Serverless?

Thanks.

-Chris


I'm curious about the use case which requires the primary key (arbitrarily assigned by the database engine) to be gaplessly consecutive through all time.


Reply via email to