---
title: "#245: Tips for dealing with Postgres locks"
publication: "Postgres Weekly"
issue: 245
published_at: "2018-02-28"
canonical_url: "https://postgresweekly.com/issues/245"
---

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

#245 — February 28, 2018 

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

Postgres Weekly  

[Why Upgrade PostgreSQL? Here's Why](https://why-upgrade.depesz.com/) — 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](https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/) — Highlights common mistakes developers face dealing with Postgres locks and what you can do about them. 

Marco Slot   [![\](https://copm.s3.amazonaws.com/86117b85.png)](https://postgresconf.org/conferences/2018) 

[PostgresConf US 2018: People, Postgres, Data](https://postgresconf.org/conferences/2018) — 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](https://www.opsdash.com/blog/postgresql-replication-slots.html) — 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](https://severalnines.com/blog/upgrading-your-database-to-postgresql-version-10) — 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](https://www.youtube.com/watch?v=GZx6TWmztMs) — 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](https://aws.amazon.com/about-aws/whats-new/2018/02/postgresql-10-now-supported-in-amazon-rds/) 

Amazon Web Services   

[Three Approaches to PostgreSQL Replication and Backup](https://www.citusdata.com/blog/2018/02/21/three-approaches-to-postgresql-replication/) 

Ozgun Erdogan   

[Postgres Backups with Continuous Archiving](http://malisper.me/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?](https://learn.percona.com/think-your-postgres-backups-and-disaster-recovery-are-safe) 

Percona sponsor   

[PostgreSQL Backup and Recovery Orchestration](https://www.zimmi.cz/posts/2018/postgresql-backup-and-recovery-orchestration-wal-archiving/) — 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](https://www.youtube.com/watch?v=Zn1vd7sQ_bc) — A talk about efforts to make Postgres (in [Patroni form](https://github.com/zalando/patroni)) 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](http://nathanmlong.com/2016/01/protect-your-data-with-postgresql-constraints/) 
Nathan Long   

[Exploring a Data Set in SQL](https://tapoueh.org/blog/2017/06/exploring-a-data-set-in-sql/) 
Dimitri Fontaine   

[Benchmarking Different UUID Generation Functions](https://jasonaowen.net/blog/2017/Apr/13/benchmarking-uuids-v2/) 
Jason Owen   

[Column Tetris: Calculating and Saving Space in Postgres Tables](https://stackoverflow.com/questions/2966524/calculating-and-saving-space-in-postgresql/7431468#7431468) 
Erwin Brandstetter          

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

[Change your email address](https://postgresweekly.com/edit_subscription/*%7CUID%7C*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*%7CUID%7C*) 

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