The Postgres community releases a major version every year that includes advanced features, functionalities, performance improvements, security enhancements, and bug fixes. PostgreSQL 14 has several features including:
Reduced index bloat on tables with frequently updated indexes
Throughput boost for workloads that use many connections
Enhancements for distributed workloads, including streaming of in-progress transaction data with logical replication
Query parallelism support with Foreign Data Wrappers (FDW)
Improved performance vacuuming systems
Improved monitoring and observability capabilities.
Now, you can combine the benefits of PostgreSQL 14 with Flexible Server’s PostgreSQL managed database experience. Your servers are automatically upgraded to the latest supported minor versions during your server's maintenance window.
Flexible Server drop-down with supported Postgres versions
Flexible Server supports several PostgreSQL extensions including Postgres 14 to extend the functionality of the database, in addition to:
Simplify the application developmentexperience, making it easy to quickly provision, connect, and start developing by using your choice of tools integrated out of the box with GitHub, Terraform, Azure Kubernetes Service, and Web Apps.
Exercise maximum control by tuning over 225 database parameters, choosing a maintenance schedule that meets your business requirements, and choose & scale between different compute options based on your CPU and memory needs.
Secure data with full network isolation, encryption of data at rest, and encrypted connections that have full control of TLS and SSL enforcement.
Optimize costs with a Burstable compute tier that can be dynamically scaled up or down, the option to stop a development or test PostgreSQL server when not in use, or reserved instance pricing, where customers can subscribe to and save up to 64%.
To upgrade your server to PostgreSQL 14, you can follow any of the procedures documented here.
We look forward to hearing about how Flexible Server is helping you to achieve productivity and meet your goals. We’re always eager to hear from you, so please reach out to us at Ask Azure DB for PostgreSQL.