-
LOCK TABLE can harm your database's health - Cybertec
autovacuum concurrency lock table bloatHow LOCK TABLE Can Harm Your Database's Health — Frequent use of LOCK TABLE could harm your database when it conflicts with autovacuuming: “If you use LOCK on a table frequently, there is a good chance that autovacuum will never be able to successfully process that table.”
Appears in lists (1)
More like this (4)
-
Key metrics for PostgreSQL monitoring
Key metrics for PostgreSQL monitoring A depth guide on how to monitor Postgres. We learn what...
7 tips for dealing with locks
7 tips for dealing with locks Continue of above post, Marco shares 7 ways to prevent...
PostgreSQL rocks, except when it blocks: Understanding locks
PostgreSQL rocks, except when it blocks: Understanding locks Learn how to avoid using the query that...
