PostgreSQL Finally Lands Support For "REINDEX CONCURRENTLY"
Written by Michael Larabel in Free Software on 29 March 2019 at 06:00 AM EDT. 7 Comments
It's been on the project's TODO list for more than one decade but finally support for the "REINDEX CONCURRENTLY" command was added today to the PostgreSQL database server.

REINDEX CONCURRENTLY allows for read/write operations to still happen on the parent table while a reindexing operation is happening. This option will basically create a new index and then replaces the existing index at the very end of the operation. The ability to support REINDEX CONCURRENTLY was something that was talked a lot about in 2012~2013 (and their TODO entry for it dates back to 2008) while waking up today it was a surprise to see this commit land in PostgreSQL Git.

More details on PostgreSQL's REINDEX CONCURRENTLY can be found via their Wiki. This addition will also be coming in PostgreSQL 12. It's also for that next major PostgreSQL release where we might see their JIT enabled by default.
Related News
About The Author
Author picture

Michael Larabel is the principal author of and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,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 automated benchmarking software. He can be followed via Twitter or contacted via

Popular News This Week