#245 — February 28, 2018

Read on the Web

Postgres Weekly

Why Upgrade PostgreSQL? Here's Why — A helpful tool to shed light on the real benefits of upgrading from any given version of Postgres. For example: Upgrading from 9.3.2 to 10.2? This site will tell you all the benefits.

Hubert depesz Lubaczewski

When Postgres Blocks: 7 Tips for Dealing with Locks — Highlights common mistakes developers face dealing with Postgres locks and what you can do about them.

Marco Slot

PostgresConf US 2018: People, Postgres, Data — PostgresConf focuses 100% on People, Postgres, and Data through growth of the community and open source industry. All proceeds go back into the community through support of local events, meetups, webinars, and training. Join us April 16 - 20.

PostgresConf.org sponsor

PostgreSQL Replication Slots — How to make WAL archiving and streaming replication more efficient with a feature added in Postgres 9.4.


Upgrading to Postgres Version 10: What You Should Know — A short summary of how you can perform an upgrade to version 10, including what method to choose, how to prepare and what to check for after the upgrade is complete.

Vladimir Svedov

▶  The State of Postgres Replication in 2018 — A long-standing knock against Postgres has been it doesn’t have replication. The reality is a bit different, this talk from FOSDEM walks through the state of it as of 2018. (Note: Poor audio.)

Magnus Hagander video

PostgreSQL 10 Now Supported on Amazon RDS

Amazon Web Services

Three Approaches to PostgreSQL Replication and Backup

Ozgun Erdogan

Postgres Backups with Continuous Archiving — A look at how Postgres backups done via an approach called ‘continuous archiving’ work, including how to set it up and how to restore.

Michael Malis

Think Your Postgres Backups and Disaster Recovery Are Safe?

Percona sponsor

PostgreSQL Backup and Recovery Orchestration — Postgres has two types of backups logical and physical. This quick guide gives you a tour of the mechanism of physical backups in PostgreSQL.

Michal Zimmermann

Kube-Native Postgres — A talk about efforts to make Postgres (in Patroni form) work more naturally in a Kubernetes environment.

Josh Berkus, RedHat

Golden Oldies ✨

From time to time, we want to link back to some popular links from the past (or even some we missed). Here's the first batch:

How to Protect Your Data with Constraints
Nathan Long

Exploring a Data Set in SQL
Dimitri Fontaine

Benchmarking Different UUID Generation Functions
Jason Owen

Column Tetris: Calculating and Saving Space in Postgres Tables
Erwin Brandstetter