The biggest Postgres news in 2017

.

Read this on the Web

Postgres Weekly 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 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] Noriyoshi Shinoda Five Novelties in PostgreSQL 10 A look at some Postgres 10 features including native partitioning & multicolumn statistics. Jakub Wilkowski The Major Features in Postgres 10 [PDF] Bruce Momjian   #news  State of Production Database Performance 2017 In this report we explore and definitively answer whether MySQL or PostgreSQL is truly faster than the other. VividCortex    #sponsored  Incompatible Changes in Postgres 10 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 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 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 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 A neat demonstration of using common table expressions to provide extra assistance to other queries. Eric Satterwhite A Postgres Response to Uber [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 Michael Stoltz PostgreSQL Cheat Sheet: The Basics Sahil Sawhney Get Postgres Certified to Score Open Source Job Opportunities 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 Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK