---
title: "This Week's PostgreSQL News (#131)"
publication: "Postgres Weekly"
issue: 131
published_at: "2015-11-11"
canonical_url: "https://postgresweekly.com/issues/131"
---

Postgres Weekly 131   . 

[Read this on the Web](http://postgresweekly.com/issues/131) 

[Postgres Weekly](http://postgresweekly.com) Issue 131 — November 11, 2015     

[PostgreSQL Locking Revealed](http://blog.nordeus.com/dev-ops/postgresql-locking-revealed.htm?utm_source=postgresweekly&utm_medium=email)Locking is at the core of many databases with the various levels ensuring [ACID](https://en.wikipedia.org/wiki/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. Nordeus [PGConf Silicon Valley PostgreSQL Conference](http://www.pgconfsv.com/program/schedule?utm_source=postgresweekly&utm_medium=email)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](http://www.eventbrite.com/e/pgconf-silicon-valley-2015-tickets-16521286613?discount=PGSVPW20). pgconfsv.​com [Hate Fixing Bugs? Lucky You. We Love It.](http://corgibytes.com)Tackling technical debt and integrating disparate systems is fun, too. (Yes, really.) Corgibytes#sponsored[![\](https://copm.s3.amazonaws.com/b6e5138a.png)](http://corgibytes.com) [pg_panic to Test Deployment Robustness with Postgres](http://michael.otacoo.com/postgresql-2/pg-panic-robustness-testing/?utm_source=postgresweekly&utm_medium=email)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. Michael Paquier [Using JSON Extensions in PostgreSQL from Python](https://www.compose.io/articles/using-json-extensions-in-postgresql-from-python-2/?utm_source=postgresweekly&utm_medium=email)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. compose.​io [Deep Dive Into PostgreSQL Statistics [slides\]](http://blog.postgresql-consulting.com/2015/11/deep-dive-into-postgresql-statistics.html?utm_source=postgresweekly&utm_medium=email)Slides that look at Postgres’ statistics collector and how to use data Postgres collects to analyze its performance, look for bottlenecks, etc. Alexey Lesovsky [Postgres Performance Observability (or Where Postgres Spends Its Time)](http://blog.postgresql-consulting.com/2015/11/postgresql-observability-views.html?utm_source=postgresweekly&utm_medium=email)From the slide deck above comes a diagram giving some context as to what happens where. Alexey Lesovsky [Postgres 9.6 Feature Highlight: Operator and Function Pushdown with postgres_fdw](http://michael.otacoo.com/postgresql-2/postgres-9-6-feature-highlight-pushdown-improvements-postgres-fdw/?utm_source=postgresweekly&utm_medium=email) Michael Paquier [Inquerest: URL Parameter Parser for REST Filter Inquiry](https://github.com/ivanceras/inquerest?utm_source=postgresweekly&utm_medium=email)Inspired by [PostgREST’s filter expressions](https://github.com/begriffs/postgrest/wiki/Routing), here’s a nice Rust library for parsing complex URLs directly into REST query expressions. GitHub#code [Become A Magnet For The Best Job Offers](https://hired.com/?utm_source=postgresweekly&utm_medium=email&utm_campaign=q4_15-petercooperpress&utm_term=job&utm_content=111115-magnet)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. Hired.​com#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/131) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK