Forum Widgets
Latest Discussions
September 2024 Recap: Azure Postgres Flexible Server
September 2024 Recap: Azure Postgres Flexible Server This month we've introduced: DiskANN Vector Index - Preview Postgres 17 - Preview Fabric Mirroring - Private Preview Migration Service โ Now supports Amazon Aurora, Google Cloud SQL, Burstable SKU, Custom FQDN Auto Migrations โ Single to Flexible server Python SDK Update Automation Tasks โ Generally Available Dive into the details and discover how these updates can improve your database management and security.Link -https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/september-2024-recap-azure-postgres-flexible-server/ba-p/4270479PostgreSQL 17 Preview on Azure Postgres Flexible Server
We recently announced the ๐ฝ๐ฟ๐ฒ๐๐ถ๐ฒ๐ ๐ผ๐ณ ๐ฃ๐ผ๐๐๐ด๐ฟ๐ฒ๐ฆ๐ค๐ ๐ญ๐ณ on Azure Database for PostgreSQL - ๐๐น๐ฒ๐ ๐ถ๐ฏ๐น๐ฒ ๐ฆ๐ฒ๐ฟ๐๐ฒ๐ฟ! :party_popper: This release brings exciting new features like improved query performance, dynamic logical replication, enhanced JSON functions, and moreโall backed by Azureโs reliable managed services. Try out the preview now and share your feedback! For details, read the complete blog post๐ https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/postgresql-17-preview-on-azure-postgres-flexible-server/bc-p/4263877#M474 #PostgreSQL #AzurePostgres #PGConfNYC #Database #OpenSourceAug 2024 Recap: Azure PostgreSQL Flexible Server
Aug 2024 Recap: Azure PostgreSQL Flexible Server This month we've introduced: Reserved pricing for Intel & AMD V5 SKUs Support for the latest Postgres minor versions New extensions like "postgres_protobuf" and "postgresql_anonymizer" Updates to Ansible modules and DNS record management Enhanced migration services including support for TimescaleDB New capabilities for Burstable SKU migrations And more! Dive into the details and discover how these updates can improve your database management and security. Read the full blog post :link: -https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/aug-2024-recap-azure-postgresql-flexible-server/ba-p/4238812#postgres-minor-versionsJuly 2024 Recap: Azure PostgreSQL Flexible Server
July 2024 Feature Recap for Azure Database for PostgreSQLFlexible Server ๐ฆ๐๐๐๐ฒ๐บ ๐๐๐๐ถ๐ด๐ป๐ฒ๐ฑ ๐ ๐ฎ๐ป๐ฎ๐ด๐ฒ๐ฑ ๐๐ฑ๐ฒ๐ป๐๐ถ๐๐ - Securely integrate your PostgreSQL Flexible Server with other Azure services. ๐๐ฎ๐๐๐ฒ๐ฟ ๐ฅ๐ฒ๐ฐ๐ผ๐๐ฒ๐ฟ๐ ๐ณ๐ผ๐ฟ ๐ฃ๐ผ๐ถ๐ป๐-๐ถ๐ป-๐ง๐ถ๐บ๐ฒ ๐ฅ๐ฒ๐ฐ๐ผ๐๐ฒ๐ฟ๐ (๐ฃ๐๐ง๐ฅ) - Recovery Point Objective reduced from 15 minutes to just 5 minutes for enhanced data protection. ๐ก๐ฒ๐ '๐๐ฎ๐๐ฎ๐ฏ๐ฎ๐๐ฒ ๐ฆ๐ถ๐๐ฒ' ๐ ๐ผ๐ป๐ถ๐๐ผ๐ฟ๐ถ๐ป๐ด ๐ ๐ฒ๐๐ฟ๐ถ๐ฐ - Gain detailed insights into database storage usage to optimize performance. ๐๐๐๐ผ๐บ๐ฎ๐๐ฒ๐ฑ ๐๐ป๐ฑ๐ฒ๐ ๐ง๐๐ป๐ถ๐ป๐ด ๐๐ป๐ต๐ฎ๐ป๐ฐ๐ฒ๐บ๐ฒ๐ป๐๐ - Automatic performance improvements with new index recommendations. ๐๐๐ ๐๐ป๐ต๐ฎ๐ป๐ฐ๐ฒ๐บ๐ฒ๐ป๐๐ - Community-driven updates to the Azure CLI for PostgreSQL enhance usability. ๐จ๐ฝ๐ด๐ฟ๐ฎ๐ฑ๐ฒ๐ฑ ๐๐๐๐ฟ๐ฒ ๐๐ฎ๐๐ฎ ๐๐ฎ๐ฐ๐๐ผ๐ฟ๐ ๐๐ผ๐ป๐ป๐ฒ๐ฐ๐๐ผ๐ฟ - Simplified error handling and improved guides based on user feedback. ๐ฃ๐๐๐ผ๐ป๐ณ.๐ฑ๐ฒ๐ ๐ฎ๐ฌ๐ฎ๐ฐ ๐ฃ๐ฎ๐ฟ๐๐ถ๐ฐ๐ถ๐ฝ๐ฎ๐๐ถ๐ผ๐ป โ Azure Postgres team shared valuable PostgreSQL insights and engaged with the community in Vancouver. Explore all the new features in detail on our blog. #AzurePostgreSQL #DatabaseManagement #TechUpdates #PostgreSQLJune 2024 Recap: Azure PostgreSQL Flexible Server
June 2024 Feature Recap for Azure Database for PostgreSQL Flexible Server ๐ ๐ฎ๐ท๐ผ๐ฟ ๐ฉ๐ฒ๐ฟ๐๐ถ๐ผ๐ป ๐จ๐ฝ๐ด๐ฟ๐ฎ๐ฑ๐ฒ๐ ๐ ๐ฎ๐ฑ๐ฒ ๐ฆ๐ถ๐บ๐ฝ๐น๐ฒ - Seamlessly upgrade to PostgreSQL 16 with minimal downtime (Now GA). ๐ก๐ฒ๐ ๐ ๐ถ๐ป๐ผ๐ฟ ๐ฉ๐ฒ๐ฟ๐๐ถ๐ผ๐ป ๐จ๐ฝ๐ฑ๐ฎ๐๐ฒ๐ - Keep your server updated with the latest PostgreSQL minor versions effortlessly. ๐ฃ๐ด๐๐ฒ๐ฐ๐๐ผ๐ฟ ๐๐ ๐๐ฒ๐ป๐๐ถ๐ผ๐ป - Discover new capabilities in Pgvector v0.7.0, enhancing your database's performance (Now GA). ๐ ๐ถ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป ๐ฆ๐ฒ๐ฟ๐๐ถ๐ฐ๐ฒ ๐๐บ๐ฝ๐ฟ๐ผ๐๐ฒ๐บ๐ฒ๐ป๐๐ - Enhanced tools and updates streamline your migration processes. ๐ฅ๐ฒ๐๐ฎ๐บ๐ฝ๐ฒ๐ฑ ๐ง๐ฟ๐ผ๐๐ฏ๐น๐ฒ๐๐ต๐ผ๐ผ๐๐ถ๐ป๐ด ๐๐๐ถ๐ฑ๐ฒ๐ - Newly updated guides to efficiently resolve database issues. ๐๐ ๐ฝ๐ฎ๐ป๐ฑ๐ฒ๐ฑ ๐ฅ๐ฒ๐ด๐ถ๐ผ๐ป๐ฎ๐น ๐ฆ๐๐ฝ๐ฝ๐ผ๐ฟ๐ - Introducing support for China North 2 and China East 2 regions. ๐๐ป๐ต๐ฎ๐ป๐ฐ๐ฒ๐ฑ ๐๐ฎ๐ฐ๐ธ๐๐ฝ ๐ข๐ฝ๐๐ถ๐ผ๐ป๐ - Long-term backup support now available for CMK-enabled servers (Preview). ๐๐ถ๐ด๐ต๐น๐ถ๐ด๐ต๐๐ ๐ณ๐ฟ๐ผ๐บ ๐ฃ๐ข๐ฆ๐๐ง๐ง๐ ๐ฎ๐ฌ๐ฎ๐ฐ - Dive into the insights shared at Azure PostgreSQL sessions! Big shout out to our engineering and product teams for their fantastic work on these features! :party_popper: Dive deeper into the details on our blog post here.May 2024 Recap: Azure PostgreSQL Flexible Server
May 2024 Recap: Azure PostgreSQL Flexible Server New Updates for Azure Database for PostgreSQL Flexible Server (May 2024 Recap) ๐ฆ๐๐ฝ๐ฒ๐ฟ๐ฐ๐ต๐ฎ๐ฟ๐ด๐ฒ ๐๐ ๐๐ป๐๐ฒ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป - Seamlessly connect Azure AI services directly in your database (azure_ai extension - GA). ๐จ๐น๐๐ฟ๐ฎ-๐๐ผ๐ ๐๐ฎ๐๐ฒ๐ป๐ฐ๐ ๐๐ - Generate text embeddings directly within your database for enhanced security (azure_local_ai extension - Preview). ๐๐๐๐ผ๐บ๐ฎ๐๐ฒ ๐ณ๐ผ๐ฟ ๐ฃ๐ฒ๐ฎ๐ธ ๐ฃ๐ฒ๐ฟ๐ณ๐ผ๐ฟ๐บ๐ฎ๐ป๐ฐ๐ฒ - Let Azure optimize your database indexes for you (Automated Index Tuning - Preview). ๐๐๐ป๐ฎ๐บ๐ถ๐ฐ ๐๐ข๐ฃ๐ฆ ๐ฆ๐ฐ๐ฎ๐น๐ถ๐ป๐ด - Pay only for the performance you need (IOPS Scaling - GA). ๐๐บ๐ฝ๐ฟ๐ผ๐๐ฒ๐ฑ ๐๐ฎ๐๐ฎ ๐ง๐ฟ๐ฎ๐ป๐๐ณ๐ผ๐ฟ๐บ๐ฎ๐๐ถ๐ผ๐ป - The CAST function now supports even more complex data manipulation. ๐ฆ๐บ๐ฎ๐ฟ๐๐ฒ๐ฟ ๐๐ฎ๐๐ฎ๐ฏ๐ฎ๐๐ฒ ๐ ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐ - Get personalized recommendations from Azure Advisor. Check out our new May 2024 Recap blog post for all the details and see how these changes can help you.Need feedback on blog post "What's new with Postgres at Microsoft, 2024 edition"
Just published this brand new deep-dive of a blog post to share highlights of all the Azure & the open source work done by the Postgres team at Microsoft over the last 8 months. The title: What's new with Postgres at Microsoft, 2024 edition. // And would like to know: do you find this useful?? The post contains a detailed infographic (handmade) that gives you a visual outline of all the different Postgres workstreams our engineering & PM teams have been driving. And because the Postgres 17 code freeze just happened last month, I included highlights from some of the new PG17 capabilities our Postgres contributor team worked on as well. If you're an Azure Database for PostgreSQL - Flexible Server customer, you won't be disappointed. Lots of new features rolled out in the last 8 months.April 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.March 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/4107275February 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/4089037
