News for hackers. Stuff that matters.

A comment on Postgres sequences can skip 32 unexpectedly. Parent comment

Re:Postgres sequences can skip 32 unexpectedly by SahAssar on Friday July 16, 2021 @04:45AM (#27854222)
It can still leak information, like if a companies customers have sequential id's and your id is 590 then it is reasonable to assume that the company has had around 500-600 customers.

It is usually not something to worry about, but in some cases you want to avoid leaking that info.

[ Parent | on HN ]
Re:Postgres sequences can skip 32 unexpectedly by Symbiote on Friday July 16, 2021 @09:15AM (#27855884)
The German Tank Problem is one example of this.

The Allies estimated how many tanks Germany was producing based on the serial numbers, and this gave a closer result compared to other intelligence sources.

https://en.wikipedia.org/wiki/German_tank_problem

[ Parent | on HN ]
Re:Postgres sequences can skip 32 unexpectedly by laurent92 on Friday July 16, 2021 @09:30AM (#27856025)
Or Jira tickets. When you submit two support cases in a few days and the number increased by 20 while the company is still a startup, you are pretty sure to have no decent answer.
[ Parent | on HN ]
Re:Postgres sequences can skip 32 unexpectedly by combatentropy on Friday July 16, 2021 @10:51PM (#27863241)
So is that a bug or a feature ;)
[ Parent | on HN ]