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

Postgres Weekly Issue 49 - March 5, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/49)**Postgres Weekly****Issue 49**
March 5, 2014[PostgreSQL Prefers the Scenic Route](http://www.linuxinsider.com/story/Bruce-Momjian-PostrgreSQL-Prefers-the-Scenic-Route-80045.html?utm_source=postgresweekly&utm_medium=email)Postgres is much akin to the tortoise more than the hare, being slow and methodical in its approach. Here are some great insights into that philosophy and the Postgres approach from someone thats been involved with the project since the early days._LinuxInsider_[PostgreSQL Participating in Google Summer of Code 2014](http://www.postgresql.org/about/news/1509/?utm_source=postgresweekly&utm_medium=email)Google will be funding several students to work with mentors from our project in order to hack PostgreSQL code for the summer._PostgreSQL.org_[PG Commander: A Modern Postgres Client for the Mac](https://eggerapps.at/pgcommander/?utm_source=postgresweekly&utm_medium=email)Inspired by “Sequel Pro”, developer Jakob Egger decided to write a truly Mac-like Postgres GUI. PG Commander is optimized for usability from the moment you first open it. Available at a 30% discount until March 15._Egger AppsSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/20206/125.png)](https://eggerapps.at/pgcommander/?utm_source=postgresweekly&utm_medium=email)[Row Security in PostgreSQL - Overview and Current Status](http://blog.2ndquadrant.com/postgresql-row-security-overview/?utm_source=postgresweekly&utm_medium=email)Row security provides the ability for you to expose different data to different sets of people easily, among other things. Here’s a first look at some of whats going into 9.4 to deliver an improved experience here._Craig Ringer_[PostgreSQL Gains Support For Logical Decoding](http://www.phoronix.com/scan.php?page=news_item=MTYyMTM?utm_source=postgresweekly&utm_medium=email)Logical decoding just made it into PostgreSQL 9.4. While not full logical replication this lays much of the groundwork for it to continue to be improved and puts relevant pieces into the core of Postgres._Phoronix_[Tracking Month over Month Growth in SQL](http://www.craigkerstiens.com/2014/02/26/Tracking-MoM-growth-in-SQL/?utm_source=postgresweekly&utm_medium=email)Querying simple values with SQL is easy, but often when looking to do something more complicated its dumped into Excel or some other tool. Here’s a look from myself at doing more complicated calculations in particular reporting deltas between values._Craig Kerstiens_[Getting Audit Logs to use Hstore](http://penningpence.blogspot.com/2014/02/getting-audit-logs-to-use-hstore.html?utm_source=postgresweekly&utm_medium=email)Hstore is an extremely powerful and flexible datatype. By taking advantage of it you can do things that are normally high effort such as using it to create a full audit log of changes to your system._Payal Singh_[Integrated Cache Invalidation for Better Hit Rates [PDF\]](http://www.hagander.net/talks/cache_invalidation_2014.pdf?utm_source=postgresweekly&utm_medium=email)Slides from a great talk given at both FOSDEM PGDay and Confoo around how your application and database can play better for cache invalidation to improve overall performance._Magnus Hagander_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)