DZone Database Zone
When Postgres Blocks: 7 Tips for Dealing With Locks
Recently, I wrote about locking behavior in Postgres, which commands block each other, and how you can diagnose blocked commands. Of course, after the diagnosis, you may also want a cure. With Postgres, it is possible to shoot yourself in the foot, but Postgres also offers you a way to stay on target. These are some of the important dos and don'ts that we've seen as helpful when working with users to migrate from their single node Postgres database to Citus or when building new real-time analytics apps on Citus.
1. Never Add a Column With a Default ValueA golden rule of PostgreSQL is: when you add a column to a table in production, never specify a default.
No comments:
Post a Comment