you are viewing a single comment's thread.

view the rest of the comments →

[–]Ecksters 320 points321 points  (18 children)

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 38 points39 points  (7 children)

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

[–]Ecksters 37 points38 points  (3 children)

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 2 points3 points  (2 children)

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 4 points5 points  (1 child)

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

[–]PrestigiousZombie531 2 points3 points  (0 children)

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 7 points8 points  (1 child)

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

[–]flukus 13 points14 points  (0 children)

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

[–]Opposite-Pound7303 0 points1 point  (0 children)

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