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
FREE SOFTWARE --
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.
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