Ten of my favorite new things in Postgres 10.
- Replacement for SERIAL (identity column)
- Traceable COMMIT
- Parallel query
- Cross-column statistics
- New collation (sorting)
- More XML
- logical replication
- Simplifying timestamps
- Renaming & renumbering
- Security tweaks
We spend a chunk of time explaining the surprisingly troublesome nature of the Postgres-specific `SERIAL` and how it is now gladly replaced by SQL-standard identity columns. Another chunk of time is spent on the practicalities of determining if a transaction completed successfully or not, now made easier with traceable COMMIT. Then we accelerate moving faster and faster through the remaining items, looking at the nooks and crannies of new features that I found useful for my own work and that you may not have yet discovered.
Updated 2018-01.
By Basil Bourque.
LinkedIn: basilbourque