Re:PG Casts – Postgres Screencasts
by teddyh on Friday June 17, 2016 @05:12AM
(#11921501)
Primary keys: INTEGER, BIGINT or UUID?
[ Parent
| on HN ]
Re:PG Casts – Postgres Screencasts
by philliphaydon on Friday June 17, 2016 @06:37AM
(#11921805)
HiLo
For those who don’t know what it is:
https://vladmihalcea.com/2014/06/23/the-hilo-algorithm/
Basically, it optimizes for lots of insert operations by using a composite primary key, one of which is a SERIAL assigned by the server, and the other is a value arbitrarily assigned by the client. This allows a client to assign and use many new unique keys without asking the server for a new value for every individual row.
Re:PG Casts – Postgres Screencasts
by jbranchaud on Friday June 17, 2016 @08:21AM
(#11922159)
and natural keys!