PostgreSQL performance varies between different releases. Every new version comes with added features and performance improvements that help the growing adoption of PostgreSQL. All these continuous These ongoing developments and improvements drive us to plan on upgrading our PostgreSQL environments, but that's not always an easy task. A few common concerns when it comes to upgrading PostgreSQL are extended downtime, converting the tables partitioned using triggers to declarative partitions, the search for the safest options to upgrade and the effort required in the upgrading process itself. In this talk we'll discuss the variety of options available that can help you upgrade your PostgreSQL servers in the best possible way.
This talk includes:
- The most significant performance improvements in recent PostgreSQL versions including PostgreSQL 11 and 10.
- A summary of features that have been implemented with every new version since PostgreSQL 9.1.
- What is it that you need to consider before upgrading your PostgreSQL server.
- What are the options you have available to help you upgrade your PostgreSQL server.
- What are the solutions available to minimize the downtime during upgrades.
- A list of parameters you need to consider in particular when upgrading PostgreSQL to 10 or 11.