Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
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 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.