PostgreSQL Sorting Is Now Up To 400% Faster

Tom Smykowski
4 min readOct 30, 2022

The new PostgreSQL database is released. From this article you will learn about five most important features.

PostgreSQL was born 26 years ago. It is available on Windows, Linux, MacOS and on BSD systems. It is a popular database choice for its stability, performance, rich set of features and continuous support.

The fifteenth version of, so called, Postgres involved over three hundred engineers from all around the world. It comes with hundreds of bug fixes and improvements. It is one of the biggest open source projects of all times.

Today I will brief you in into five most important features of PostgreSQL 15:

Conditional data processing with MERGE command

You will love the MERGE command if you have to procedurally process data, but wished for a better way.

The better way is called the MERGE. I love examples, so here’s one:

As you can see the syntax for MERGE resembles a if/else, or even better: switch statement.

--

--

Tom Smykowski

Software Engineer & Tech Editor. Top 2% on StackOverflow, 3mil views on Quora. Won Shattered Pixel Dungeon.