Adding or dropping indexes 📒 in a live PostgreSQL database means locking the entire table, potentially causing application slowdowns or outages. Use CONCURRENTLY with CREATE INDEX or DROP INDEX to perform the operation in the background. #postgres