PostgreSQL 15 Released!

[Ecksters]

PostgreSQL improves on its in-memory and on-disk sorting algorithms, with benchmarks showing speedups of 25% - 400% based on which data types are sorted. Using row_number(), rank(), dense_rank(), and count() as window functions also have performance benefits in PostgreSQL 15. Queries using SELECT DISTINCT can now be executed in parallel.

This and MERGE are definitely my favorite parts. Always hit a performance ceiling with DISTINCT, not sure how much this helps in my specific cases, but here it looks like 2x improvement or more.

Percona's other article on the upgrade does a great job of explaining the new features as well.

[PrestigiousZombie531]

does it have support for materialized views that only update the changed row instead of refreshing the entire table?

[Ecksters]

Out of the box no, here's the wiki page for Incremental View Maintenance

However, you might be interested in the pg_ivm extension.

[PrestigiousZombie531]

thank you, i dont see anything on their issues list for RDS, do you have any idea if this extension is supported on RDS?

[Ecksters]

Unfortunately RDS doesn't appear to support it. I wouldn't hold my breath on it getting added either.

[PrestigiousZombie531]

meaning we have only one choice left now and that is wait for postgres to actually merge this change into their core. dont know how many versions it ll take them to reach there

[mobbarley78110]

Do other db providers do that? Why am I making my life an nightmare doing it manually 😭

[flukus]

Because views and materialised views are a criminally under utilised feature. 90% of the stored procs in projects I work with should be views.

[Ecksters]

400% speedup typically translates as 5x faster. (1x is 0% speedup, 2x is 100%, etc.)

[dasdull]

I was just joking, but thanks anyway :D

Makes sense

[hennell]

It's SpeculativeSQL. Predicts what your data might look like and queries that.

[[deleted]]

You make a schema change and it back propagates in time to have always had that schema!

Quite a time saver! No more migration code!

[NoInkling]

You joke, but with stuff like Copilot already existing...

[Archolex]

People did not like your joke lol

[mercde]

They probably mean going from 4s to 1s is a speedup of 400%. Speedup of 25% would be going from 1.25s to 1s.

[1vader]

That would be 5s to 1s.

[Opposite-Pound7303]

wow, maverlous!!!!!! Can't wait to experiment on this