---
title: "The biggest Postgres news in 2017"
publication: "Postgres Weekly"
issue: 237
published_at: "2017-12-20"
canonical_url: "https://postgresweekly.com/issues/237"
---

Postgres Weekly 237   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 237 — December 20, 2017      

What a huge year 2017 was for Postgres! In this issue we're reflecting on the biggest stories and best tutorials of 2017, so if you've missed any issues, this is a great time to catch up.
 
 Due to Christmas, our next issue will be on January 10. Happy holidays! :-) 

[PostgreSQL 10 (Was) Released](https://www.postgresql.org/about/news/1786/)Released in October, this was clearly _the_ Postgres news of the year. The next few links are handy resources to what's new. Postgres.​org#news 

[Postgres 10's New Features with Examples [PDF\]](http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_10_New_Features_en_20170522-1.pdf) Noriyoshi Shinoda 

[Five Novelties in PostgreSQL 10](https://10clouds.com/blog/postgresql-10/)A look at some Postgres 10 features including native partitioning & multicolumn statistics. Jakub Wilkowski 

[The Major Features in Postgres 10 [PDF\]](http://momjian.us/main/writings/pgsql/features.pdf) Bruce Momjian#news 

[State of Production Database Performance 2017](https://www.vividcortex.com/resources/state-of-production-database-performance-2017?utm_campaign=Postgres%20Weekly&utm_source=ppc&utm_medium=State%20of%20Production)In this report we explore and definitively answer whether MySQL or PostgreSQL is truly faster than the other. VividCortex#sponsored — [![\](https://copm.s3.amazonaws.com/3dd5438a.png)](https://www.vividcortex.com/resources/state-of-production-database-performance-2017?utm_campaign=Postgres%20Weekly&utm_source=ppc&utm_medium=State%20of%20Production) 

[Incompatible Changes in Postgres 10](http://paquier.xyz/postgresql-2/postgres-10-incompatible-changes/)Just prior to Postgres 10's release, Michael Paquier looked at a variety of incompatible changes to be aware of before upgrading. Michael Paquier#news 

[Upgrading From 9.6 to 10 with Minimal Downtime using pglogical](https://rosenfeld.herokuapp.com/en/articles/infrastructure/2017-11-10-upgrading-postgresql-from-9-6-to-10-with-minimal-downtime-using-pglogical)One approach of using pglogical to switch from 9.6 to 10 in ‘just a few seconds’. Rodrigo Rosenfeld Rosas 

[A Look at PostgreSQL 9.6's Parallel Queries](https://blog.rebased.pl/2017/04/24/postgresql-9-6-parallel-queries.html)A major feature in 9.6 was the parallel execution of sequential scans, joins and aggregates. Here’s a very high level look at what that means. Tomasz Stachewicz 

[A Tour of Postgres Index Types](https://www.citusdata.com/blog/2017/10/17/tour-of-postgres-index-types/)Postgres has a rich set of index types from standard b-tree to GIN and GiST. Craig Kerstiens 

[Building JSON API Responses With Postgres CTEs](http://www.codedependant.net/2017/04/30/build-json-api-responses-postregres-with-cte/)A neat demonstration of using common table expressions to provide extra assistance to other queries. Eric Satterwhite 

[A Postgres Response to Uber [PDF\]](http://thebuild.com/presentations/uber-perconalive-2017.pdf)Last year Uber switched from Postgres to MySQL, here Christophe Pettus goes through the reasons why. Christophe Pettus 

[Migrating from DynamoDB to Postgres: Why and How](https://containership.engineering/dynamodb-to-postgres-why-and-how-aa891681af4d) Michael Stoltz 

[PostgreSQL Cheat Sheet: The Basics](https://blog.knoldus.com/2017/04/30/postgresql-cheat-sheet-basics/) Sahil Sawhney 

[Get Postgres Certified to Score Open Source Job Opportunities](https://www.enterprisedb.com/blog/certify-score-open-source-jobs)50% of hiring managers are more likely to hire a certified professional. Open source skills are in demand. EnterpriseDB#sponsored     

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/237) [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