Presented by:

Software Developer, working with micro-startups & small teams to build niche software, typically database-backed desktop-style enterprise-oriented web apps running server-side in pure Java on the Vaadin framework.

Previously worked in long-term client engagements building in-house custom-crafted departmental database apps for cost accounting, business operations, and workflow.

Also spent a couple years as a trainer teaching software development (database, business logic, and user-interface) to developers both novice and expert in week-long seminars.

Hobbies include extreme dog-walking and welding bird-cages. And spending way too much time on Stack Overflow.

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.

Download slides (PDF).

Date:
Duration:
45 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2019
Language:
Track:
Postgres Track
Difficulty:
Medium

Happening at the same time:

  1. Syncthing + your favorite password manager = Zero-trust password syncing between devices.
  2. Start Time:
    2019 April 28 09:30

    Room:
    CC-114

  3. Anatomy of a Deprecation
  4. Start Time:
    2019 April 28 09:30

    Room:
    CC-235

  5. Command Line for Kids of All Ages
  6. Start Time:
    2019 April 28 09:30

    Room:
    CC-115

  7. MySQL 8 Features for Developers
  8. Start Time:
    2019 April 28 09:30

    Room:
    CC-208

  9. FreeBSD at Work
  10. Start Time:
    2019 April 28 09:30

    Room:
    HC-108

  11. Calling all FLOSS Founders
  12. Start Time:
    2019 April 28 09:30

    Room:
    G-103

  13. Try Linux Tutorium
  14. Start Time:
    2019 April 28 09:30

    Room:
    CC-234

  15. 11 in 11
  16. Start Time:
    2019 April 28 09:30

    Room:
    HC-103 Postgres

  17. The Fight for a Secure Linux BIOS… Past, Present and Future
  18. Start Time:
    2019 April 28 09:30

    Room:
    CC-236

  19. Mozilla Project Things (IoT) -- Open Framework for Decentralized, Private, Secure, and Interoperable Web Things
  20. Start Time:
    2019 April 28 09:30

    Room:
    CC-202 Tutorials

  21. Linux Professional Institute Exam Lab
  22. Start Time:
    2019 April 28 09:30

    Room:
    HC-112 LPI

  23. Women in cybersecurity!
  24. Start Time:
    2019 April 28 09:30

    Room:
    HC-104 Jupiter

  25. Chat Ops - Everything old is new again
  26. Start Time:
    2019 April 28 09:30

    Room:
    CC-200

  27. Digital painting in Krita
  28. Start Time:
    2019 April 28 10:00

    Room:
    CC-201 Tutorials