How to prevent table lock when add/drop index in Postgres?
Posted by
By
Posted inAll topics, Architecture & Design, Database, PostgreSQLTags: optimize performance, Postgresql
By
Posted inAll topics, Architecture & Design, Database, PostgreSQLTags: optimize performance, PostgresqlThe CONCURRENTLY option in PostgreSQL is used when creating or dropping indexes to avoid locking the entire table during the process. It's especially useful in production environments where you want…
