Locking is at the core of many databases with the various levels ensuring ACID compliance. But locking is also one of the first areas to look at when problems arise. Here’s a wonderful primer on the types of locking that exist in Postgres and what they mean.
PGConf Silicon Valley is just around the corner and features an array of awesome talks from many members of the Postgres community. If you find yourself in the Bay Area and are looking to expand your knowledge next week, give it a look with our discount code of 20% off just for PG Weekly readers.