PostgreSQL 18 Preview on Azure Database for PostgreSQL
PostgreSQL 18 Preview on Azure Postgres Flexible Server Weโre excited to bring the latest Postgres innovations directly into Azure. With PG18 Preview, you can already test: ๐น Asynchronous I/O (AIO) โ faster queries & lower latency ๐น Vacuuming enhancements โ less bloat, fewer replication conflicts ๐น UUIDv7 support โ better indexing & sort locality ๐น B-Tree skip scan โ more efficient use of multi-column indexes ๐น Improved logical replication & DDL โ easier schema evolution across replicas And thatโs just the start โ PG18 includes hundreds of community contributions, with 496 from Microsoft engineers alone ๐ช ๐ Try it out today on Azure Postgres Flexible Server (initially in East Asia), share your feedback, and help shape GA.PostgreSQL 17 General Availability with In-Place Upgrade Support
Weโre excited to share that PostgreSQL 17 is now Generally Available on Azure Database for PostgreSQL โ Flexible Server! This release brings community-driven enhancements including improved vacuum performance, smarter query planning, enhanced JSON functions, and dynamic logical replication. It also includes support for in-place major version upgrades, allowing customers to upgrade directly from PostgreSQL 11โ16 to 17 without needing to migrate data or change connection strings. PostgreSQL 17 is now the default version for new server creations and major version upgrades. ๐ Read the full blog post: http://aka.ms/PG17 Let us know if you have feedback or questions!June 2023 Update: Azure Database for PostgreSQL Flexible Server Unveils New Features
The Azure Database for PostgreSQL Flexible Server's June 2023 update is live! Now enjoy: Easier major version upgrades with reduced downtime. Server recovery feature for dropped servers. A more user-friendly Connect experience. Improved server performance with new IO enhancements. Auto-growing storage and online disk resize, now in public preview. We also support minor versions PostgreSQL 15.2 (preview), 14.7, 13.10, 12.14, 11.19. Big thanks to our dedicated team! Check out our blog for more details: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/june-2023-recap-azure-database-postgresql-flexible-server/ba-p/3868650July 2023 Recap: Azure Database PostgreSQL Flexible Server
July 2023 Recap: Azure Database PostgreSQL Flexible Server Support for PostgreSQL 15 is now available (general availability). Automation Tasks have been introduced for Streamlined Management (preview phase). Flexible Server Migration Tooling has been enhanced (general availability). Hardware Options have been expanded with the addition of AMD Compute SKUs (general availability). These updates represent substantial improvements in performance, scalability, and efficiency. Whether you are a developer, a Database Administrator (DBA), or an individual passionate about PostgreSQL, we trust that these enhancements will contribute positively to your experience with our platform. Should you find these updates valuable, we encourage you to engage with us through appropriate channels of communication. Thank you for your continued support and interest in Azure Database for PostgreSQL Flexible Server.Autoscaling with Azure: A Comprehensive Guide to PostgreSQL Optimization Using Azure Automation Task
Autoscaling Azure PostgreSQL Server with Automation Tasks Read our latest article detailing the power of Autoscaling the Azure Database for PostgreSQL Flexible Server using Azure Automation Tasks. This new feature can revolutionize how we manage resources, streamlining operations, and minimizing human error.August 2023 Recap: Azure Database for PostgreSQL Flexible Server
Absolutely thrilled to unveil our latest blog post, " ๐๐๐ด๐๐๐ ๐ฎ๐ฌ๐ฎ๐ฏ ๐ฅ๐ฒ๐ฐ๐ฎ๐ฝ: ๐๐๐๐ฟ๐ฒ ๐๐ฎ๐๐ฎ๐ฏ๐ฎ๐๐ฒ ๐ณ๐ผ๐ฟ ๐ฃ๐ผ๐๐๐ด๐ฟ๐ฒ๐ฆ๐ค๐ ๐๐น๐ฒ๐ ๐ถ๐ฏ๐น๐ฒ ๐ฆ๐ฒ๐ฟ๐๐ฒ๐ฟ ". This month is jam-packed with feature updates designed to amplify your experience! 1. ๐๐๐๐ผ๐๐ฎ๐ฐ๐๐๐บ ๐ ๐ผ๐ป๐ถ๐๐ผ๐ฟ๐ถ๐ป๐ด - Elevate your database health with improved tools and metrics. 2. ๐๐น๐ฒ๐ ๐ถ๐ฏ๐น๐ฒ ๐๐ก๐ฆ ๐ญ๐ผ๐ป๐ฒ ๐๐ถ๐ป๐ธ๐ถ๐ป๐ด - Simplify your server setup process for multiple networking models. 3. ๐ฆ๐ฒ๐ฟ๐๐ฒ๐ฟ ๐ฃ๐ฎ๐ฟ๐ฎ๐บ๐ฒ๐๐ฒ๐ฟ ๐ฉ๐ถ๐๐ถ๐ฏ๐ถ๐น๐ถ๐๐ ๐ฒ๐ป๐ต๐ฎ๐ป๐ฐ๐ฒ๐บ๐ฒ๐ป๐๐ - Now view hidden parameters for better performance optimization. 4. ๐ฆ๐ถ๐ป๐ด๐น๐ฒ ๐๐ผ ๐๐น๐ฒ๐ ๐ถ๐ฏ๐น๐ฒ ๐ฆ๐ฒ๐ฟ๐๐ฒ๐ฟ ๐ ๐ถ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป ๐ง๐ผ๐ผ๐น๐ถ๐ป๐ด โ Simplified migration experience with automated extension allow listing. Don't miss out! Read the full scoop here: August 2023 Recap: Azure Database for PostgreSQL Flexible ServerNovember 2023 Recap: Azure PostgreSQL Flexible Server
Excited to share our November 2023 updates for Azure Database for PostgreSQL Flexible Server Server Logs management has been streamlined for better monitoring and troubleshooting, along with customizable retention periods. Embracing the latest in security, we now support TLS Version 1.3, ensuring the most secure and efficient client-server communications. Migrations are smoother with our new Pre-Migration Validation feature, making your transition to Flexible Server seamless. Microsoft Defender integration, providing proactive anomaly detection and real-time alerts to safeguard your databases. Additionally, we've upgraded user and role migration capabilities for a more accurate and hassle-free experience. ๐ฅ Link - https://lnkd.in/gMMGaiAK Stay tuned for more updates, and feel free to share your experiences with these new features!February 2024 Recap: Azure PostgreSQL Flexible Server
Azure database for PostgreSQL Flexible Server - Feb '24 Feature Recap: General Availability of ๐ฃ๐ฟ๐ถ๐๐ฎ๐๐ฒ ๐๐ป๐ฑ๐ฝ๐ผ๐ถ๐ป๐๐ across all public Azure regions for secure, flexible connectivity. ๐๐ฎ๐๐ฒ๐๐ ๐ฒ๐ ๐๐ฒ๐ป๐๐ถ๐ผ๐ป ๐๐ฒ๐ฟ๐๐ถ๐ผ๐ป๐ to enhance your PostgreSQL performance and security. ๐๐ฎ๐๐ฒ๐๐ ๐ฃ๐ผ๐๐๐ด๐ฟ๐ฒ๐ ๐บ๐ถ๐ป๐ผ๐ฟ ๐๐ฒ๐ฟ๐๐ถ๐ผ๐ป๐ (16.1, 15.5, 14.10, 13.13, 12.17, 11.22) now supported for automatic upgrades. Enhanced ๐ ๐ฎ๐ท๐ผ๐ฟ ๐ฉ๐ฒ๐ฟ๐๐ถ๐ผ๐ป ๐จ๐ฝ๐ด๐ฟ๐ฎ๐ฑ๐ฒ ๐๐ผ๐ด๐ด๐ถ๐ป๐ด for smoother upgrades. ๐ฝ๐ด๐๐ฒ๐ฐ๐๐ผ๐ฟ ๐ฌ.๐ฒ.๐ฌ introduced for better vector similarity searches. ๐ฅ๐ฒ๐ฎ๐น-๐๐ถ๐บ๐ฒ ๐๐ฒ๐ ๐ ๐๐ฟ๐ฎ๐ป๐๐น๐ฎ๐๐ถ๐ผ๐ป now available with Azure_AI extension. Easier ๐ข๐ป๐น๐ถ๐ป๐ฒ ๐ ๐ถ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป from Single Server to Flexible Server in public preview. We recommend reading our latest blog post to explore these updates in detail - https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/february-2024-recap-azure-postgresql-flexible-server/ba-p/4089037March 2024 Recap: Azure PostgreSQL Flexible Server
Azure Database for PostgreSQL - Flexible Server March'24 Feature Recap ๐ ๐ถ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป ๐ ๐ฎ๐ฑ๐ฒ ๐๐ฎ๐๐: Seamlessly transfer PostgreSQL instances with Migration Service (GA). ๐๐ฎ๐๐ฒ๐๐ ๐ฃ๐ผ๐๐๐ด๐ฟ๐ฒ๐ ๐ ๐ถ๐ป๐ผ๐ฟ ๐ฉ๐ฒ๐ฟ๐๐ถ๐ผ๐ป๐: Automatically updated to include Postgres versions 16.2, 15.6, 14.11, 13.14, and 12.18. ๐ฃ๐ผ๐๐๐ด๐ฟ๐ฒ๐ ๐ญ๐ฒ ๐ ๐ฎ๐ท๐ผ๐ฟ ๐ฉ๐ฒ๐ฟ๐๐ถ๐ผ๐ป ๐จ๐ฝ๐ด๐ฟ๐ฎ๐ฑ๐ฒ: Test drive the newest features of PostgreSQL 16 with minimal disruption. ๐๐ ๐ฃ๐ฟ๐ฒ๐ฑ๐ถ๐ฐ๐๐ถ๐ผ๐ป๐ ๐ถ๐ป ๐ฅ๐ฒ๐ฎ๐น-๐ง๐ถ๐บ๐ฒ: Integrate machine learning predictions directly within your database with Azure_AI. ๐ก๐ฒ๐ ๐ ๐ผ๐ป๐ถ๐๐ผ๐ฟ๐ถ๐ป๐ด ๐ ๐ฒ๐๐ฟ๐ถ๐ฐ: Monitor 'Database Size' for precise capacity planning and performance optimization. Team Microsoft delivered impactful sessions and engaged with the community in Bengaluru @ PGConf India. Check out our blog for a full rundown of March's updates and how they can empower your projects - https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/march-2024-recap-azure-postgresql-flexible-server/ba-p/4107275April 2024 Recap: Azure PostgreSQL Flexible Server
April 2024 Recap: Azure PostgreSQL Flexible Server - ๐๐ถ๐๐ฎ๐๐๐ฒ๐ฟ ๐ฅ๐ฒ๐ฐ๐ผ๐๐ฒ๐ฟ๐ ๐๐บ๐ฝ๐ฟ๐ผ๐๐ฒ๐บ๐ฒ๐ป๐๐: updates to read replicas ensure seamless disaster recovery with minimal downtime. - ๐ก๐ฒ๐ ๐ฃ๐ด๐๐ผ๐๐ป๐ฐ๐ฒ๐ฟ ๐ญ.๐ฎ๐ฎ.๐ญ: Experience enhanced connection pooling for better performance and stability. - ๐๐ฎ๐๐ถ๐ฒ๐ฟ ๐ข๐ป๐น๐ถ๐ป๐ฒ ๐ ๐ถ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป: Move from Single Server to Flexible Server without stopping your work. - ๐๐ ๐๐ฒ๐ป๐๐ถ๐ผ๐ป ๐จ๐ฝ๐ฑ๐ฎ๐๐ฒ๐: keep your database extensions up to date with ease. - ๐๐ฎ๐๐ฒ๐๐ ๐๐ ๐๐ฒ๐ป๐๐ถ๐ผ๐ป ๐ฉ๐ฒ๐ฟ๐๐ถ๐ผ๐ป๐: From TimescaleDB to PostGIS, leverage the latest functionalities to enhance your data management. Check out our new April 2024 Recap blog post for all the details and see how these changes can help you.
