PostgreSQL

Adding an index per column is not an indexing strategy. Column order in composite indexes determines whether they get used…

Adding a column sounds harmless. Adding one with a non-null default on a large table can lock it for the…