PostgreSQL 11 Is Continuing With More Performance Improvements, JIT'ing
Written by Michael Larabel in Free Software on 23 May 2018 at 05:55 AM EDT. 5 Comments
FREE SOFTWARE --
PostgreSQL 11 is the next major feature release of this open-source database SQL server due out later in 2018. While it's not out yet, their release notes were recently updated for providing an overview of what's coming as part of this next major update.

To little surprise, performance improvements remain a big focus for PostgreSQL 11 with various optimizations as well as continued parallelization work and also the recently introduced just-in-time (JIT) compilation support.

- Improvements to partitioning with allowing partitioning by hash key and behavior changes to UPDATE/SELECT/PRIMARY KEY.

- Improvements to parallelism with parallelized hash joins, parallelized CREATE INDEX, and other parallelized work.

- SQL stored procedures handling with support for embedded transactions.

- JIT compilation of some SQL code. This is what we began talking about back in March for LLVM JIT support for PostgreSQL to lead to faster performance.

- Various other performance improvements.

The in-progress SGML release notes provide the current list of highlights for the upcoming PostgreSQL 11.0. There is also the PostgreSQL TODO page as part of their Wiki.

About The Author
Author picture

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 10,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter or contacted via MichaelLarabel.com.

Related Free Software News
Popular News This Week