---
title: "#251: The Story of A Mega Postgres 10 Upgrade"
publication: "Postgres Weekly"
issue: 251
published_at: "2018-04-11"
canonical_url: "https://postgresweekly.com/issues/251"
---

The latest Postgres news, articles, tools, and projects.       

#251 — April 11, 2018 

[Read on the Web](https://postgresweekly.com/issues/251)   

Postgres Weekly  

[The Story of A Mega Postgres 10 Upgrade](https://bricklen.github.io/2018-03-27-Postgres-10-upgrade/) — The challenge: Upgrading 1500 Postgres database clusters from version 9.3 to 10, in six data centres, with sizes ranging from ~1GB to 500+GB within a downtime window of 15 minutes. 

Bricklen A   

[My Favorite Postgres Queries and Why They Matter](https://severalnines.com/blog/my-favorite-postgresql-queries-and-why-they-matter) — An interesting combination of queries the author has found to be interesting/engaging to explore, study, and learn from. 

Joshua Otwell   [![\](https://copm.s3.amazonaws.com/e1a8838d.png)](http://postgresvision.com/) 

[Convince Your Boss to Send You to Postgres Vision in Boston](http://postgresvision.com/) — Whether you work for a start-up, a government agency, or an enterprise, we realize it can be difficult to justify your time out of the office and the cost of attending a conference. Get your justification letter and register today. 

POSTGRES VISION 2018 sponsor   

[Giving Raw SQL Access to Users with Row Level Security](https://www.citusdata.com/blog/2018/04/04/raw-sql-access-with-row-level-security/) — Postgres’s row level security support provides a powerful primitive for giving direct access to a database while still limiting access to certain data. Also, [Postgres documentation.](https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.html) 

Craig Kerstiens   

[Building Real Time Analytics APIs at Scale](https://blog.algolia.com/building-real-time-analytics-apis/) — Algolia recently redesigned their analytics API, in order to provide near real-time analytics, and handle billions of search queries per day. Here’s how they did it, using Postgres as the datastore. 

Sylvain Friquet   

[PostgreSQL Bloatbusters](http://blog.dataegret.com/2018/03/postgresql-bloatbusters.html) — Vacuum’s goal is generally to keep bloat under control, but sometimes it’s not enough. What are your options _then_? 

Alexey Lesovsky    

[PGCon 2018 Registration Now Open](https://lists.pgcon.org/pipermail/pgcon-announce/2018-April/000154.html) — Takes place across May 29-June 1 in Ottawa, Canada. [Schedule](https://www.pgcon.org/2018/schedule/) and [tickets available here.](https://www.pgcon.org/2018/registration.php) 

Dan Langille   

[SQL:2016 MERGE SQL Command Coming to Postgres 11](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=d204ef63776b8a00ca220adec23979091564e465) — Initial support has landed in the Postgres core codebase. 

Simon Riggs   

[Postgres Privileges and Security: Locking Down the Public Schema](https://severalnines.com/blog/postgresql-privileges-and-security-locking-down-public-schema) — Details schema privileges and locking down the public schema. 

Berend Tober   

[How to Set Up Streaming Replication with Postgres 10](https://blog.raveland.org/post/postgresql_sr/) 

Pierre-Emmanuel André   

[36 Postgres 'How To's Answered](https://popsql.io/learn-sql/postgresql/) — From very simple things like renaming a table to working with CTEs and advanced filtering. 

PopSQL   

[Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-brief) 

Linode Cloud Hosting sponsor   

[Fast CSV and JSON Ingestion in Postgres with COPY](http://info.crunchydata.com/blog/fast-csv-and-json-ingestion-in-postgresql-with-copy) — COPY is also incredibly helpful for ingesting data such as JSON or CSV into a PostgreSQL table, especially if there is a lot of it. Learn how to use COPY to optimize your data loading performance. 

Jonathan S. Katz         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom