LinuxFest Northwest 2019: 11 in 11
Channel: linuxfestnorthwest
Date: 2019-05-01

Presented by Basil Bourque 

The current version of the Postgres database system is 11, released in late 2018 with over 150 new features.

Let’s take a look at about eleven of the more interesting features. Some big, some small, all useful.

    New & improved partitioning, smarter faster ways to divvy up your data on disk.
    More parallelization, to make more use of all those cores in your box.
    New INCLUDE clause when defining an index, so more queries can benefit from index-only scans.
    Just-in-Time (JIT) compilation of query plans, using modern LLVM technology, for faster access to your data
    WAL file size now configurable
    Run a transaction within your server-side code, with new CREATE PROCEDURE.
    SCRAM Authentication is even more secure.
    More SQL-standard window-functions.
    ALTER TABLE much less likely to need a table re-write.

…and more found in the best Postgres ever.