#245: Tips for dealing with Postgres locks

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

#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. OpsDash 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

Curated by Cooperpress and Craig Kerstiens Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom