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

Postgres Weekly 133   . 

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

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

[The Unofficial Guide to JSONB Operators in Postgres, Part 1](http://hasura.io/blog/the-unofficial-guide-to-jsonb-operators-in-postgres/?utm_source=postgresweekly&utm_medium=email)JSONB, or binary JSON, is the best improvement to come to Postgres in several years. Just as valuable are all the operators that come with it, here’s a rundown of them. Balaji Rao [Introduction to pg_stat_activity to Monitor DB Processes in Real Time](http://blog.postgresql-consulting.com/2015/11/introduction-to-pgstatactivity.html?utm_source=postgresweekly&utm_medium=email)pg_stat_activity provides a SQL-accessible view of Postgres’ various processes and user activity. Ilya Kosmodemiansky [PostgreSQL, The PCI Compliant Database [PDF\]](http://thebuild.com/presentations/pgconfsv-2015-pci.pdf?utm_source=postgresweekly&utm_medium=email)Slides from a PGConf Silicon Valley talk looking at how Postgres can be made PCI compliant (so that payment card processors won’t hate or block you). Christophe Pettus [Instant, deep Postgres monitoring](http://dtdg.co/1OhYXXg)Datadog natively collects hundreds of Postgres metrics: system resources, connections, locks, transactions, indexes, and more. Pre-built, fully customizable visualizations, alerts, and full-stack performance correlation. [14 day unlimited trial.](http://dtdg.co/1OhYXXg) Datadog#sponsored[![\](https://copm.s3.amazonaws.com/8b9eb348.png)](http://dtdg.co/1OhYXXg) [HyperLogLog in Pure SQL](https://www.periscopedata.com/blog/hyperloglog-in-pure-sql.html?utm_source=postgresweekly&utm_medium=email)Hyperloglog is a very interesting algorithm and you can have an extremely efficient version [directly in Postgres](https://github.com/aggregateknowledge/postgresql-hll). And if you’re not up for building and pulling in your own extensions here’s a raw SQL implementation of it. Periscope [pg_paxos: High Availability Data Replication for PostgreSQL](https://www.citusdata.com/blog/14-marco/335-pgpaxos-high-availability-table-replication-postgresql?utm_source=postgresweekly&utm_medium=email)The pg_paxos extension demonstrates how the Paxos algorithm can be used for fault-tolerant, consistent table replication in Postgres. Citus Data [Organize Complex Queries Using SQL's 'WITH'](https://modern-sql.com/feature/with?utm_source=postgresweekly&utm_medium=email)Common table expressions or more commonly known as [WITH clauses](http://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/) are very useful in Postgres. Not only can you do recursive queries, they also make simpler queries more readable. Markus Winand [RDS PostgreSQL Supports Point-and-Click Upgrade From 9.3 to 9.4](http://aws.amazon.com/about-aws/whats-new/2015/11/rds-postgresql-now-supports-point-and-click-upgrade-from-postgresql-93-to-94/?utm_source=postgresweekly&utm_medium=email) Amazon#news [Autovacuum, Explained for Engineers](http://blog.postgresql-consulting.com/2015/10/autovacuum-explained-for-engineers-new.html?utm_source=postgresweekly&utm_medium=email)Vacuum and Autovacuum have gotten much better over the years in Postgres, but their behavior can be misunderstood. Here’s an up to date slidedeck that walks you through the ins and outs. Ilya Kosmodemiansky [Get Multiple Job Offers in One Week](https://hired.com/?utm_source=postgresweekly&utm_medium=email&utm_campaign=q4_15-petercooperpress&utm_term=job&utm_content=112515-multipleoffers)Companies are looking to hire someone with your skillset. Stop applying and let companies come to you with offers, which include salary and other benefit information upfront. Hired.​com#job    

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