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

Postgres Weekly 108   . 

[Read this on the Web](http://postgresweekly.com/issues/108) 

[Postgres Weekly](http://postgresweekly.com) Issue 108 — June 3, 2015     

[Zero-Downtime Postgres Migrations: The Hard Parts](https://gocardless.com/blog/zero-downtime-postgres-migrations-the-hard-parts/?utm_source=postgresweekly&utm_medium=email) Chris Sinjakli [Stopping Time In PostgreSQL](http://blog.thefourthparty.com/stopping-time-in-postgresql/?utm_source=postgresweekly&utm_medium=email)A look at how sequential rows in a table can end up with ‘out of order’ timestamps due to the way Postgres manages times within transactions. Lauren Ellsworth [PostgreSQL: The Good, The Bad, and The Ugly](http://lwn.net/SubscriberLink/645020/e1ba36cff8248df0/?utm_source=postgresweekly&utm_medium=email)While Postgres is a great piece of software sometimes how the pudding gets made isn’t as pretty. While community members have good intentions, sometimes they just don’t see eye to eye. Here’s a bit of inside baseball among the community. Jonathan Corbet [Who Needs Training? You may want to think twice.](http://www.enterprisedb.com/store/products/dba-training?utm_source=cooperpress&utm_medium=nl&utm_campaign=ttrain)We often get asked by our customers about how to find skilled Postgres resources for their team. With Postgres training and certification from EDB, you may have that extra something an employer is looking for, to set you apart. Check out the [Foundations course](http://www.enterprisedb.com/store/products/dba-training/01t500000031mz8AAA?utm_source=cooperpress=nl=btrainfc) to get started or look over our [advanced classes](http://www.enterprisedb.com/store/products/dba-training?utm_source=cooperpress=nl=btraina). Keep your skills sharp and stay competitive. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/5cddb23d.jpg)](http://www.enterprisedb.com/store/products/dba-training?utm_source=cooperpress&utm_medium=nl&utm_campaign=ttrain) [PostgreSQL 9.5's Upsert Feature Explained](https://www.youtube.com/watch?v=pbg97bkxbbY&utm_source=postgresweekly&utm_medium=email)Peter Geoghegan explains Postgres 9.5’s recently-committed UPSERT feature in this 20 minute presentation. Peter Geoghegan#video [Can Anyone Provide A Sound Argument for Choosing MySQL Over Postgres?](https://news.ycombinator.com/item?id=9586504&utm_source=postgresweekly&utm_medium=email)It’s not easy, but some people fight MySQL’s corner pretty well. Hacker News [YeSQL: Battling the NoSQL Hype Cycle with Postgres [PDF\]](http://momjian.us/main/writings/pgsql/yesql.pdf?utm_source=postgresweekly&utm_medium=email)This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads. Bruce Momjian [What's New in PostgreSQL 9.5](https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5?utm_source=postgresweekly&utm_medium=email)Upsert isn’t the only new thing in Postgres 9.5, and while we’re still several months away from 9.5’s release the wiki is starting to show a great picture of what’s new including a brand new index type. PostgreSQL wiki [Block Range (BRIN) Indexes in PostgreSQL 9.5](http://pythonsweetness.tumblr.com/post/119568339102/block-range-brin-indexes-in-postgresql-9-5?utm_source=postgresweekly&utm_medium=email)The standard index in Postgres, a BTree index is often what you want. But, Postgres has a variety of other types, including BRIN with 9.5. Python Sweetness [Fun with Django's New Postgres Features](https://realpython.com/blog/python/fun-with-djangos-new-postgres-features/?utm_source=postgresweekly&utm_medium=email)Postgres has a lot of awesome datatypes, but if you can’t easily use them in your web framework then they’re much less useful. This post walks through several awesome and less common ones including hstore and arrays in Django. Real Python [Porting ActiveRecord Validations to Postgres](http://shuber.io/porting-activerecord-validations-to-postgres/?utm_source=postgresweekly&utm_medium=email)A look at how common ActiveRecord validations port to Postgres constraints in SQL. Sean Huber [Front-end Developer at Guidebook (Palo Alto or SOMA)](https://www.jobscore.com/jobs2/guidebook/front-end-developer/bbpx1waiOr5yXaiGalkWKP?name=Corpsite%20en%20Jobs%20page&ref=rss&sid=68&utm_source=postgresweekly&utm_medium=email)Guidebook helps people build and publish mobile apps for all types of devices. Our CMS is a huge part of that and you will play a key part in building our new CMS by collaborating with our design and back-end development teams to implement mockups and integrate with our back-end stack. Guidebook#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/108) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK