Database Index - CI/CD Glossary Definition
A database index is an auxiliary data structure (usually a B-tree) that lets the database find rows by a column without scanning the whole table, trading extra storage and slower writes for faster reads.
In CI/CD
Creating an index can lock a large table for a long time. Postgres offers CREATE INDEX CONCURRENTLY to build it without blocking writes, which is the safe choice in a zero-downtime migration.
Related guides
Primary Key - CI/CD Glossary DefinitionPrimary Key: A primary key is the column (or set of columns) that uniquely identifies each row in a table. It…
Foreign Key - CI/CD Glossary DefinitionForeign Key: A foreign key is a column that references the primary key of another table, enforcing that the r…
Online Schema Change - CI/CD Glossary DefinitionOnline Schema Change: An online schema change alters a large table without blocking reads and writes, typical…