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

Postgres Weekly 135   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 135 — December 9, 2015     

[Postgres and JSON with Node - Hands on with MassiveJS](http://www.craigkerstiens.com/2015/12/08/massive-json/?utm_source=postgresweekly&utm_medium=email)Postgres got JSON support years ago, and it only improved with JSONB. Just now ORMs and libraries are getting support, including MassiveJS, a Node package with a novel approach to letting Postgres work as a document store. Craig Kerstiens [MongoDB 3.2: Now 'Powered' by PostgreSQL?](https://www.linkedin.com/pulse/mongodb-32-now-powered-postgresql-john-de-goes?utm_source=postgresweekly&utm_medium=email)An extensive writeup about how MongoDB 3.2 will use Postgres in its ‘legacy BI connector’ so that SQL-based BI systems can operate against it. John De Goes [Emulating Row Security in PostgreSQL 9.4](http://blog.2ndquadrant.com/emulating-row-security-in-postgresql-9-4/?utm_source=postgresweekly&utm_medium=email)PostgreSQL 9.5 adds declarative row security. It’s not available in 9.4 but you can achieve a similar effect. Craig Ringer [Get Ready for 2016! What Are Your Postgres Database Resolutions?](http://www.enterprisedb.com/ahc?utm_source=cooperpress&utm_medium=nl&utm_campaign=prep2016ahc)Have you finally resolved to fix that nagging performance problem once and for all? Are you prepared for data growth in 2016? Now is the time to do a quick tune up. Evaluate your Postgres database performance with a rapid [Architectural Health Check](http://www.enterprisedb.com/ahc?utm_source=cooperpress=nl=prep2016ahc) and ensure your system is optimally configured and tuned as you start the year. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/5a01324a.png)](http://www.enterprisedb.com/ahc?utm_source=cooperpress&utm_medium=nl&utm_campaign=prep2016ahc) [The First Annual PGConf Silicon Valley Wrap Up](https://www.citusdata.com/blog/25-terry/344-first-annual-pgconf-silicon-valley-wrap-up?utm_source=postgresweekly&utm_medium=email)Great speakers, enthusiastic attendees, lively networking, and standing room only sessions were all highlights of the first annual Postgres conference in the Bay Area. Citus Data [Dictionaries and PostgreSQL FTS](http://azakirov.blogspot.com/2015/12/dictionaries-and-postgresql-fts.html?utm_source=postgresweekly&utm_medium=email)If you’re new to what it means to have ‘full text search’ capabilities, this run through should give you a great primer on how it works in Postgres as well as some practical steps. Arthur Zakirov [Choosing PostgreSQL Over MySQL or MariaDB](http://insights.dice.com/2015/12/03/choosing-postgresql-over-mysql-mariadb/?utm_source=postgresweekly&utm_medium=email) David Bolton#opinion [PostgreSQL Studio 2.0 Released](http://www.openscg.com/2015/12/postgresql-studio-2-0-is-out/?utm_source=postgresweekly&utm_medium=email)A fully open source Web-based UI for Postgres. Jim Mlodgenski [Agg: Parallel Aggregations for Postgres](http://www.cybertec.at/en/products/agg-parallel-aggregations-postgresql/?utm_source=postgresweekly&utm_medium=email)The most expensive operations in any Postgres database are generally _aggregations_. Whether it’s some sum, average, or most common counts, such operations often consume a large amount of time, but the _agg_ extension looks to improve this. Hans-Juergen Schoenig [pg_repack: Reorganize Tables in PostgreSQL Databases with Minimal Locks](https://github.com/reorg/pg_repack?utm_source=postgresweekly&utm_medium=email)Pg_repack is an interesting extension that lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. The Reorg Development Team#code [Join The Top 3% of Freelance PostgreSQL Developers Worldwide](http://www.toptal.com/developers?utm_source=cooperpress&utm_medium=newsletter&utm_content=postgres_weekly&utm_campaign=top_3)Toptal is an exclusive network of elite freelance software engineers. Apply today to work with top clients, set your own rates, and collaborate with other top PostgreSQL developers. Toptal#job [Join our team of brainiacs and be a part of the database monitoring revolution](https://www.vividcortex.com/about-us/careers/?utm_source=paid&utm_medium=pgw) Vivid Cortex#job    

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