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

Postgres Weekly Issue 52 - April 3, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/52)**Postgres Weekly****Issue 52**
April 3, 2014Did you know Postgres Weekly is now just over a year old? :-) As always, a big thanks goes to [Craig Kerstiens](https://twitter.com/craigkerstiens) for continuing to find great stuff to share.[Creating PostgreSQL Arrays Without A Quadratic Blowup](http://blog.heapanalytics.com/creating-postgresql-arrays-without-a-quadratic-blowup/?utm_source=postgresweekly&utm_medium=email)Arrays are very useful in Postgres, but depending on how you’re working with them they can have significant performance costs. Here’s one example of using arrays and a specific way to alter the usage to make them more efficient._Heap_[Subtly Bad Things Linux May Be Doing To PostgreSQL](http://rhaas.blogspot.com/2014/04/subtly-bad-things-linux-may-be-doing-to.html?utm_source=postgresweekly&utm_medium=email)_Robert Haas_[Postgres 9.4 Feature Highlight: Triggers On Foreign Tables](http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-trigger-foreign-tables/?utm_source=postgresweekly&utm_medium=email)Last week we had plenty of articles highlighting jsonb, which recently made it into Postgres 9.4. Still there’s other great features such as some improvements to foreign tables that are worth catching up on as well._Michael Paquier_[Bitcoin Weekly: Our New Cryptocurrency Newsletter](http://bitcoinweekly.com/?utm_source=postgresweekly&utm_medium=email)Together with Bitcoin guru Stanislas Marion, we’re launching a new Bitcoin and cryptocurrency focused weekly soon. If you want to sign up, [check out the sample issue](http://bitcoinweekly.com/issues/1?euid=*|UNIQID|*) and it's a single click from there :-)_Sponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/21198/125.png)](http://bitcoinweekly.com/?utm_source=postgresweekly&utm_medium=email)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|*)