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

Postgres Weekly Issue 75 - October 1, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/75)**Postgres Weekly****Issue 75**
October 1, 2014[A simple guide for DB migrations](http://www.craigkerstiens.com/2014/10/01/a-simple-guide-for-db-migrations/?utm_source=postgresweekly&utm_medium=email)Adding columns to your database can sometimes be a painful experience resulting in downtime while that new addition is made. Seldom if ever does this have to be the case with Postgres._Craig Kerstiens_[Postgres Outperforms MongoDB and Ushers in New Developer Reality](http://blogs.enterprisedb.com/2014/09/24/postgres-outperforms-mongodb-and-ushers-in-new-developer-reality/?utm_source=postgresweekly&utm_medium=email)Want to see how Postgres measures up wise to Mongo? Here’s some insights. This fortunately takes advantage of 9.4 as well and the JSONB data format to allow for a more direct comparison._EnterpriseDB_[Allocation Set Internals](http://blog.pgaddict.com/posts/allocation-set-internals?utm_source=postgresweekly&utm_medium=email)Want to learn a bit more around the internals of how memory is allocated within Postgres? Here’s a great dive into the internals of the DB itself._PostgreSQL Addict_[Take our 12-week Immersive Coding School Onsite or Online](http://www.hackreactor.com/remote-beta/?utm_source=coopermedia=oct1postgresweeklyexclusive=remotebeta?utm_source=postgresweekly&utm_medium=email)We are actively accepting applications for two new online cohorts of our 12-week immersive JavaScript coding school beginning October 27th and December 8th. Apply today for Hack Reactor Remote Beta and be on your way to becoming an Engineer._Hack ReactorSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/23801/i.png)](http://www.hackreactor.com/remote-beta/?utm_source=coopermedia=oct1postgresweeklyexclusive=remotebeta?utm_source=postgresweekly&utm_medium=email)[So You Want Another PostgreSQL Database? (Part 1)](http://engineroom.trackmaven.com/blog/so-you-want-another-postgresql-database-part-1/?utm_source=postgresweekly&utm_medium=email)There comes a time in many application’s lives where you need to scale beyond a single Postgres instance. Here’s the start of a series that starts to delve into the things you need to know and consider if you’re working to scale that yourself._John Young_[Postgres: Time Travelling Debugger](http://www.garysieling.com/blog/postgres-time-travelling-debugger?utm_source=postgresweekly&utm_medium=email)Ever interact with a system where results change over time? If so then debugging can be well… difficult. Here’s a form of keeping an audit log in Postgres to help with such._Gary Sieling_[Upcoming Postgres 9.4beta3 release](http://www.postgresql.org/message-id/26018.1412041228@sss.pgh.pa.us?utm_source=postgresweekly&utm_medium=email)After some resolution around on disk format changes to the much exciting JSONB datatype, 9.4 beta 3 is around the corner inching us every closer to the full release._postgresql.org_[Postgres 9.5 Feature Highlight: Improved Verbose Logs in pg_dump](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-improved-logs-pg-dump/?utm_source=postgresweekly&utm_medium=email)_Michael Paquier_[Toshi - Open Source Bitcoin Node](https://toshi.io/?utm_source=postgresweekly&utm_medium=email)Want you’re own bitcoin node that’s powered by Postgres? Here it is. And a great place to practice your SQL skills on a large dataset._Toshi_[Using Postgres Composite Types in Django](http://schinckel.net/2014/09/24/using-postgres-composite-types-in-django/?utm_source=postgresweekly&utm_medium=email)If you’ve ever had to deal with scheduling applications and calendaring you know what seems on the surface to be simple can create all sorts of pain. Here’s a deep dive into one solution involving composite types in PG._Matthew Schinckel_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|*)