logo
logo

PostgreSQL puts the pedal to the metal with some smart indexing tweaks in version 12

avatar
Manuel Darcangelo
Oct 04, 2019 12:56
img

Open-source database darling PostgreSQL emitted a new version of its eponymous database last night with more nods to standard SQL and a performance boost.

The performance of adding data to partitioned tables via INSERT and COPY has also been improved, as well as the critical addition of the ability to attach a new partition to a table without blocking queries.

Other indexing performance bumps from lower overheads in write-ahead log generation and the enabling of Just-in-time compilation by default should speed up the execution of expressions in WHERE.

The feature isn't new – it was introduced back in 2018's PostgreSQL 11 – but was left turned off by default.

What is new, however, and will have many administrators jumping for joy, is the arrival of REINDEX CONCURRENTLY, which can rebuild an index without blocking writes to the table.

Compatibility with SQL standards has also received a nod in the release with "generated columns" derived from other columns and a "stored" version, which will stash the computed version on disk.

collect
0
avatar
Manuel Darcangelo
Oct 04, 2019 12:56
guide
Zupyak is a free content platform for publishing and discovering stories, software and startups.