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

Postgres Weekly 103   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 103 — April 29, 2015     

[How to Fix What You Can't Kill: Undead PostgreSQL Queries](http://tech.zalando.com/posts/hack-to-terminate-tcp-conn-postgres.html?utm_source=postgresweekly&utm_medium=email)Sometimes queries keep running longer than you’d like, this creates a bit of a backup on your DB. As a result you can kill them, except when you can’t, here’s a great look at the exceptional case and how to handle it. Sandor Szuecs [HOWTO Use JSONB, The Binary Formatted JSONs in PostgreSQL](http://stormatics.com/howto-use-jsonb-the-binary-formatted-jsons-in-postgresql/?utm_source=postgresweekly&utm_medium=email)We seem to link something about JSONB, the new binary JSON format in Postgres 9.4, each week, but this takes a unique deeper dive into some of the differences from the previous JSON datatype to JSONB. Umair Shahid [When do errors happen? [Data study\]](https://opbeat.com/blog/posts/error-data-study/?utm_source=postgresweekly&utm_medium=ad&utm_campaign=postgresweeklydatastudy)Over 70% of bugs happen outside of office hours, data from 40k releases and 10m errors. [This & other facts.](https://opbeat.com/blog/posts/error-data-study/?utm_source=postgresweekly&utm_medium=ad&utm_campaign=postgresweeklydatastudy) Opbeat#sponsored[![\](http://s3.amazonaws.com/nlga/uploads/item/image/36474/t.png)](https://opbeat.com/blog/posts/error-data-study/?utm_source=postgresweekly&utm_medium=ad&utm_campaign=postgresweeklydatastudy) [Postgres: The Nice Bits](http://russ.garrett.co.uk/talks/postgres-gds/?utm_source=postgresweekly&utm_medium=email)Here’s a great set of slides from a talk about Postgres. They highlight many of the awesome parts of PG including schemas, JSON, PLs, and replication. Russ Garrett [Postgres: The Bits You Haven't Found](https://vimeo.com/61044807?utm_source=postgresweekly&utm_medium=email)An older but still very relevant talk around many of the awesome bits that most don’t discover in Postgres. A great shotgun talk highlighting CTEs, arrays, ranges, pub/sub, and so much more. Peter van Hardenberg#video [Scaling out PostgreSQL for CloudFlare Analytics using CitusDB](https://blog.cloudflare.com/scaling-out-postgresql-for-cloudflare-analytics-using-citusdb/?utm_source=postgresweekly&utm_medium=email)CitusDB provides horizontally scalable Postgres, you can download and trial it today, or read here to see how Citus powers CloudFlare’s dashboard. CloudFlare [Postgres at the Center of Everyone’s Data World](http://www.enterprisedb.com/postgres-plus-edb-blog/jason-davis/postgres-center-everyone-s-data-world?utm_source=postgresweekly&utm_medium=email)A relational database as the system of record is incredibly common, and Postgres is increasingly at the core of it. Yet, in today’s world you have more than one system and connecting them can be a good bit of work. Foreign Data Wrappers or FDWs can go a long way here. EnterpriseDB [Space Elephant - Meteor Postgres](http://www.meteorpostgres.com/?utm_source=postgresweekly&utm_medium=email)Meteor and Postgres - PostgresSQL with Node-Postgres on the back-end and miniSQL with AlaSQL (our version of minimongo) on the front-end. Space Elephant    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/103) [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