4 ms·
I’d like to see a true monotonic counter in Postgres. Serials can increment out of order when multiple transactions are active. We can obtain the WAL LSN, but i
by WilcoKruijer 1y ago
I’d like to see a true monotonic counter in Postgres. Serials can increment out of order when multiple transactions are active. We can obtain the WAL LSN, but it’s not related to the currently active transaction. I really like FoundationDB’s versionstamp, would be great to have that in Postgres.
- DumBthInker007 1y agoThanks for the reply,will surely look into it.
- dapperdrake 1y agoHow is a "true monotonic counter" supposed to interact with atomicity and isolation of transactions? Sounds like a global bottleneck. Is uniqueness sufficient or is it really required to step through all integers without missing any? EDIT: Missing primary keys in-between also bothers me, however, never found a decent solution for this at scale.