10 in 10: Ten new things in Postgres 10
Delve into details of new features delivered in Postgres 10
Schedule

Presented by:

Df06000516b540a9d7d58309f9ad1a18

Basil Bourque

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.

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.

Date:
Duration:
1 h 30 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2018
Language:
Track:
PostgreSQL
Difficulty:
Medium

Happening at the same time:

  1. 10 in 10: Ten new things in Postgres 10
    2. Start Time:
    2018 April 28 05:30

    Room:
    HC-103 Postgres

  2. Programmers are Evil
    3. Start Time:
    2018 April 28 06:00

    Room:
    HC-108

  3. OpenSource: Love what you do everyday!
    4. Start Time:
    2018 April 28 06:00

    Room:
    G-103

  4. Successful 2FA is a matter of smooth workflows
    5. Start Time:
    2018 April 28 06:00

    Room:
    CC-200

  5. Orchestrating Multi-service Applications on Kubernetes
    6. Start Time:
    2018 April 28 06:00

    Room:
    CC-235

  6. GO generate all the things!
    7. Start Time:
    2018 April 28 06:00

    Room:
    CC-236

  7. Better Brewing through Data Science and Machine Learning
    8. Start Time:
    2018 April 28 06:00

    Room:
    CC-208

  8. The Ubuntu Home Server
    9. Start Time:
    2018 April 28 06:00

    Room:
    CC-115

  9. The business case for copyleft
    10. Start Time:
    2018 April 28 06:00

    Room:
    CC-114