How to Create a PostgreSQL Index Without Blocking Writes
On a PostgreSQL table serving a live web application, a regular index build can cause an outage because it holds a lock while PostgreSQL scans the table and…
Read articleTopic
An index helps a database find rows without reading the whole table. It also takes space and adds work when data changes.