Bringing PostgreSQL Towards Zero Downtime Migration with Python

Bringing PostgreSQL Towards Zero Downtime Migration with Python

Discover strategies for achieving near-zero downtime migrations in PostgreSQL using Python in this conference talk. Learn how to overcome the challenge of modifying large-scale database structures without significant service interruptions. Explore the latest improvements in PostgreSQL 9.4, including logical replication, and see how they can be leveraged alongside Python scripting with psycopg to minimize downtime during migrations. Gain insights into techniques being developed at orderbird for handling tables with millions or billions of records efficiently. Understand the advantages of SQL databases and how to mitigate their structural modification challenges in long-running projects.