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

Performance:

  • 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 -  https://events.enterprisedb.com/event/f42c0bd2-fdee-4ea9-964d-91a2cb981c56/summary?RefId=web

Dallas – June 15 - https://events.enterprisedb.com/event/3cf3e3f5-c0fd-49fc-bb1f-87bf231bbb79/summary?RefId=web

NYC – July 24 - https://events.enterprisedb.com/event/5d15c626-a174-4ae9-8114-7c39901ff88b/summary?RefId=web

Chicago – July 31 - https://events.enterprisedb.com/event/5d7163ce-c55d-4ef3-ba7f-9d243e19a52b/summary?RefId=web

Anonymous
Parents Comment Children
No Data
Related Content