Issues » 52

Archives   Read this issue on the Web
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.
Heap
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 :-)

Sponsored Item
GIN As A Substitute for Bitmap Indexes
If you’re coming from another DB system and used to bitmap indexes, GIN is essentially your replacement. If you’re wondering when you’d even want either, the short of it is when you have multiple values in the same column, or in this case when you may have lots of duplicate values within a result set.
Heikki Linnakangas
Gracefully Restart PostgreSQL with PGBouncer
PGBouncer is the connection pooler to use for Postgres, but what happens when you have to reboot your Postgres instance? Here’s a quick tip that will make your life a lot easier.
Hans Hasselberg
Announcing walctl for PostgreSQL Transaction Log Management
Adding to the existing tools in WAL-E and barman, here’s another promising tool to help manage your disaster recovery process with Postgres.
Shaun M. Thomas
Issue 7 of DB Weekly, our general purpose database newsletter
We looked at WebScaleSQL, a collaboration to build upon MySQL, the growing role of real-time in-memory databases, MongoDB, and more. Check out our latest issue and if you like it, it's just a single click to subscribe.
Cooper Press
Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2014 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK
Update your email address
or unsubscribe here

ONE e-mail each Wednesday. Easy to unsubscribe. No spam — your e-mail address is safe
Published by Cooper Press and curated by Craig Kerstiens