What is the purpose of CREATE INDEX CONCURRENTLY in PostgreSQL?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What is the purpose of CREATE INDEX CONCURRENTLY in PostgreSQL?

Key points

  • This option allows for concurrent index creation
  • Reads and writes can continue during the index build
  • Longer build time compared to traditional index creation
  • Helps maintain database availability during index creation

Ready to go further?

Related questions