---
title: "This Week's PostgreSQL News (#167)"
publication: "Postgres Weekly"
issue: 167
published_at: "2016-07-27"
canonical_url: "https://postgresweekly.com/issues/167"
---

Postgres Weekly 167   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 167 — July 27, 2016     

[Why Uber Engineering Switched from Postgres to MySQL](https://eng.uber.com/mysql-migration/?utm_source=postgresweekly&utm_medium=email)Uber Engineering explains the technical reasoning behind its switch in database technologies _from_ Postgres _to_ MySQL - an uncommon direction to migrate in. Evan Klitzke [Reading a Postgres EXPLAIN ANALYZE Query Plan](https://robots.thoughtbot.com/reading-an-explain-analyze-query-plan?utm_source=postgresweekly&utm_medium=email)Postgres can provide a lot of insight into how a particular query performs by looking at its ‘EXPLAIN’ plan. This article breaks down how to read them properly. Caleb Thompson#tutorial [Postgres in Production at GoCardless](https://www.youtube.com/watch?v=Tu-cf-Jki60&utm_source=postgresweekly&utm_medium=email)A 40 minute look at “lessons learned the hard way” using Postgres at payment firm GoCardless. Filmed at the recent PGDayUK conference. Chris Sinjakli#video [RAM increased across all plans. Now get 2GB of RAM for only $10/mo.](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly)Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code`POSTGRES20` Linode#sponsored[![\](https://copm.s3.amazonaws.com/9925772c.png)](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly) [Using SQL to Monitor a PostgreSQL Database](http://www.vertabelo.com/blog/technical-articles/using-sql-to-monitor-a-postgresql-database?utm_source=postgresweekly&utm_medium=email)Under the covers Postgres keeps track of a lot about your database, locks, running queries, and more. Getting access to it isn’t hard you just need to know where to look and what to query. This is a great primer as some of the numbers you can get out of your system to help monitor. Maria Alcaraz#tutorial [Upcoming Changes for pg_get Functions on Invalid Objects in 9.6](http://michael.otacoo.com/postgresql-2/postgres-9-6-behavior-change-pg-get/?utm_source=postgresweekly&utm_medium=email) Michael Paquier#news [My Favorite PostgreSQL Feature: Insert / Update CTEs](https://www.coderedux.com/on-postgresql/insert-update-cte?utm_source=postgresweekly&utm_medium=email)CTEs are often talked about for making SQL more readable, or when you need recursion in a single query. They also have other powerful cases such as when updating some already existing data. David Toomey#opinion [API automation for PostgreSQL](https://www.dreamfactory.com/signup/instant-api-for-postgresql?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=postgres)Instant dev portal from any PostgreSQL database. DreamFactory#sponsored#tools [Sharding Postgres with Semi-Structured Data](https://www.citusdata.com/blog/2016/07/25/sharding-json-in-postgres-and-performance/?utm_source=postgresweekly&utm_medium=email)Last week we saw [a post](https://www.citusdata.com/blog/2016/07/14/choosing-nosql-hstore-json-jsonb/) that talked about the benefits of hstore, JSON, and JSONB. This post goes a step further at how you might use JSONB as a key in data modeling along with how you could scale by sharding. Citus Data [Tips for Using psql: Postgres's Command Line Client](http://mccalljt.io/blog/2016/07/psql-tips/?utm_source=postgresweekly&utm_medium=email)If you don’t need a GUI editor, there’s a great tool that comes with Postgres - psql. Jack McCallum [Postgres Custom Range Types for GeoIP](http://illuminatedcomputing.com/posts/2016/06/inet-range/?utm_source=postgresweekly&utm_medium=email)A look at how to define your own range types in Postgres. Paul A.​ Jungwirth [Geolocation using Multiple Services](https://blog.garage-coding.com/2016/07/06/geolocation-using-multiple-services.html?utm_source=postgresweekly&utm_medium=email)Building a PostGIS-supported system that queries free geolocation services and aggregates their results. Stefan Petrea [Get 5+ Engineering Job Offers in 1 Week](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly)With Hired, companies apply to hire you - get salary and equity offers before you interview from companies like Facebook, Postmates, & Square Hired.​com#sponsored    

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