Chris van Eijk: Invoice numbers per tenant in PostgreSQL, without gaps

T2Covered by 1 source · first reported by Planet PostgreSQL at 27 Sept, 22:30 UTC

Sequence, max()+1, SERIALIZABLE or a counter row: five ways to number invoices per tenant, measured under load in PostgreSQL 17 for duplicates, gaps and speed.

cloud

Sources

• T2Chris van Eijk: Invoice numbers per tenant in PostgreSQL, without gapsPlanet PostgreSQL27 Sept, 22:30