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

Postgres Weekly 96   . 

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

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

[Goodbye MongoDB, Hello PostgreSQL](http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/?utm_source=postgresweekly&utm_medium=email)Mongo offers great promises of developer agility by not having to worry about your data model, yet data does have structure that sometimes needs to be managed. Here’s yet another (though awesome and detailed story) of someone moving from Mongo to Postgres highlighting the why and how they did it. Yorick Peterse#opinion [Understanding EXPLAIN [PDF\]](http://www.dalibo.org/_media/understanding_explain.pdf?utm_source=postgresweekly&utm_medium=email)Postgres' query plans are powerful and useful, but not always intelligible. There are some really short and simple [guides](http://www.craigkerstiens.com/2013/06/13/explaining-your-data/) that exist, but this one surpasses them all. Dalibo#tutorial [Sharpen your Postgres Skills with 9.4 Training](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tsharpen)Special 2 courses in 1: Comprehensive PostgreSQL Administration taught by Community Leader Bruce Momjian. Whether you’re an established professional or new to Postgres, sharpen your skills and level up with expert Postgres Training. Save 20% now with promo code COMB-PGW-02. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/864cc1f3.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tsharpen) [Postgres.app 9.4.1.0 Released](http://postgresapp.com/?utm_source=postgresweekly&utm_medium=email)The easiest way to get started with Postgres on the Mac now features Postgres 9.4.1 and PostGIS 2.1.5. Jakob Egger#news [Performance since PostgreSQL 7.4 / pgbench](http://blog.pgaddict.com/posts/performance-since-postgresql-7-4-to-9-4-pgbench?utm_source=postgresweekly&utm_medium=email)In the database world, benchmarks are a dime a dozen. But it’s often useful to see how a certain database is improving against itself between releases. Here’s a look at transaction throughput of Postgres between releases back to 7.4 over 10 years ago. PostgreSQL Addict [Fujitsu Adding Column-Oriented Processing Engine to PostgreSQL](http://www.datanami.com/2015/03/04/fujitsu-adding-column-oriented-processing-engine-to-postgresql/?utm_source=postgresweekly&utm_medium=email)Fujitsu is working on a vector-processing-based, column-oriented storage engine for analyzing data stored in a Postgres database. Datanami#news [How to manage and monitor your existing Postgres servers](http://severalnines.com/blog/how-manage-and-monitor-your-existing-postgres-servers?utm_source=postgresweekly&utm_medium=email)Cluster control is a tool that helps you monitor your backups, queries, and performance, and is now available for Postgres. Severalnines#tools [pguri: uri type for PostgreSQL](https://github.com/petere/pguri?utm_source=postgresweekly&utm_medium=email)For a few years now myself and a [few others](https://twitter.com/ascherbaum/status/567531315054903298) have wanted some more tailored types in Postgres for application development. Among those were a uri and email datatype and today thanks to [@petereistentraut](http://www.twitter.com/petereisentraut) one of those is available. Peter Eisentraut#code [Job: Software Engineer @ Blue Apron (New York, NY)](https://www.blueapron.com/pages/jobs?gh_jid=11091&utm_source=postgresweekly&utm_medium=email)If you're passionate about food and building supply chain and warehouse management systems from the ground up, give us a look. Our team's at 16 developers and growing...quickly. Blue Apron#sponsored#job    

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