Postgres Weekly Issue 52
April 3, 2014
Did you know Postgres Weekly is now just over a year old? :-) As always, a big thanks goes to Craig Kerstiens for continuing to find great stuff to share.
Creating PostgreSQL Arrays Without A Quadratic Blowup
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.
Subtly Bad Things Linux May Be Doing To PostgreSQL
Robert Haas
Postgres 9.4 Feature Highlight: Triggers On Foreign Tables
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
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 and it's a single click from there :-)