Issue #237: The biggest Postgres news in 2017

Postgres Weekly 237

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

See our archives

Change your email address

Stop getting this newsletter

Published by Cooperpress
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK

Issue 236 #237 Issue 238