LinuxFest Northwest 2018: 10 In 10: Ten New Things In Postgres 10
Channel: linuxfestnorthwest
Date: 2018-05-03

Basil Bourque

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.