Re: Sequence gaps after restart

2021-05-11 Thread Tom Lane
Christopher Sumner 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

Re: Sequence gaps after restart

2021-05-11 Thread Rob Sargent
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

Re: Sequence gaps after restart

2021-05-11 Thread Magnus Hagander
On Tue, May 11, 2021 at 5:55 PM 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 seque

Sequence gaps after restart

2021-05-11 Thread Christopher Sumner
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