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.

Tackling technical debt and integrating disparate systems is fun, too. (Yes, really.)

pg_panic is a tool that will sometimes trigger a PANIC and crash all the backends when a query is issued. Why? To test how robust your setup and fallbacks are.

Just in case you haven’t read Postgres Weekly recently, Postgres and JSON together are awesome ;-) Here’s another, but still awesome, guide to using Postgres and JSON directly from within Python.

Slides that look at Postgres’ statistics collector and how to use data Postgres collects to analyze its performance, look for bottlenecks, etc.

From the slide deck above comes a diagram giving some context as to what happens where.

Inspired by PostgREST’s filter expressions, here’s a nice Rust library for parsing complex URLs directly into REST query expressions.

In one week, you can have interview requests from the industry’s hottest companies - without ever sending in an application. What are you waiting for? Join Hired today.