Deep Thoughts by Dave Orlandi (SNL reference....kidding, I kid.)

A couple of weeks ago, I was able to attend the Postgres conference in Chicago - PGDay. It was an intimate affair...maybe 100 attendees...but those who participated were able to absorb some great Postgres sessions.

I was able to sit in on a couple of them and I thought I would share one session in particular.

**(This is a very small subset of information shared...I wasn't able to write notes fast enough...)

Postgres v. 16 Preview - Magnus Hagander from Redpill Linpro (Stockholm, Sweden):

Magnus reviewed four main areas of improvement in Postgres to come in version 16.

  • DBA/Administration
  • SQL / Development
  • Backup / Replication
  • Performance

Some highlights from the first 3 topics above…

  • More detail from pg_stat_io
  • SQL Standard JSON constructors and predicates
  • pg_dump – compression support
  • Logical Replication
    • Parallel workers on subscriptions
    • New role – create_sub for Security *(run as table owner vs SuperUser)
    • Can replicate from standby


  • Runs FASTER (up to 26x!) (Faster memory management)
  • Explicit SIMD (Single Instruction, Multiple Data) support
  • Group By / Distinct (smarter sort orders)

I encourage you to attend an upcoming Postgres conference. If you do, please visit the Quest booth.

DC – June 6 -

Dallas – June 15 -

NYC – July 24 -

Chicago – July 31 -

Related Content