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

Postgres Weekly Issue 48 - February 26, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/48)**Postgres Weekly****Issue 48**
February 26, 2014[PostgreSQL 9.3.3, 9.2.7, 9.1.12, 9.0.16 and 8.4.20 Released](http://www.postgresql.org/about/news/1506/?utm_source=postgresweekly&utm_medium=email)An epic set of minor releases this week, principally for rolling out security fixes, although there are also some fixes for replication and data integrity issues._postgresql.org_[The Costs of A PostgreSQL Connection](http://hans.io/blog/2014/02/19/postgresql_connection/index.html?utm_source=postgresweekly&utm_medium=email)Contrary to what many believe a connection to Postgres isn’t ‘free.’ Here’s a look at the overhead of connections and some suggestions as to the solution, though in reality there are a few more options available._Hans Hasselberg_[DreamFactory: Open Source REST API for Postgres](http://bitnami.com/stack/dreamfactory?utm_source=postgresweekly&utm_medium=email)DreamFactory provides an open source REST API for any SQL database. Generate a live documented REST API for your Postgres database in minutes. Install the free open source package on EC2, VMWare, Azure, Linux, or OS X._DreamFactorySponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/19761/i.png)](http://bitnami.com/stack/dreamfactory?utm_source=postgresweekly&utm_medium=email)[Why HStore2/jsonb Is The Most Important Patch of 9.4](http://www.databasesoup.com/2014/02/why-hstore2jsonb-is-most-important.html?utm_source=postgresweekly&utm_medium=email)As was highlighted last week there’s many things that [missed PostgreSQL 9.4](http://www.craigkerstiens.com/2014/02/15/PostgreSQL-9.4-What-I-Wanted/) and others that are on the cusp. Here’s a take from a core developer why HStore2 and jsonb are so important._Josh Berkus_[Using PostgreSQL Arrays The Right Way](http://blog.heapanalytics.com/dont-iterate-over-a-postgres-array-with-a-loop/?utm_source=postgresweekly&utm_medium=email)Arrays in Postgres are very useful and worth looking into, although not without knowing what the performance implications are. Essentially, avoid accessing positions directly in arrays, as there’s a better option._Dan Robinson_[Creating Triggers In PostgreSQL](http://www.bitsntricks.com/creating-triggers-postgresql/?utm_source=postgresweekly&utm_medium=email)Need replication of data, auditing of changes in your DB, or enforcement of business rules? Triggers can help and this article highlights how._Shiv Aggarwal_[Streaming Replication Slots in PostgreSQL 9.4](http://blog.2ndquadrant.com/postgresql-9-4-slots/?utm_source=postgresweekly&utm_medium=email)If replication has been a mystery to you in Postgres, here’s a great dive into one specific piece: replication slots._Craig Ringer_[PostgreSQL, Aggregates and Histograms](http://tapoueh.org/blog/2014/02/21-PostgreSQL-histogram.html?utm_source=postgresweekly&utm_medium=email)Postgres has an abundance of built-in [functions](http://www.postgresql.org/docs/9.3/static/functions.html), some of these are commonly used, some less so. Taking advantage of some of the mathematical ones you can easily generate histograms directly with SQL._Dimitri Fontaine_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|*)