News for hackers. Stuff that matters.
Re:PG Casts – Postgres Screencasts by teddyh on Friday June 17, 2016 @05:12AM (#11921501)
Primary keys: INTEGER, BIGINT or UUID?
Re:PG Casts – Postgres Screencasts by philliphaydon on Friday June 17, 2016 @06:37AM (#11921805)
HiLo
Re:PG Casts – Postgres Screencasts by teddyh on Friday June 17, 2016 @07:12AM (#11921922)
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!