It’s time to take advantage of the faster architecture and stronger value of Azure Database for PostgreSQL – Flexible Server. A recent study by Principled Technologies compares the performance and cost of Azure Database for PostgreSQL – Flexible Server to Azure Database for PostgreSQL – Single Server (slated for retirement March 28, 2025). Overall, Flexible Server offers 4.71 times the number of new orders per minute (NOPM) for significantly faster performance in online transaction processing (OLTP) on top of faster transactions per minute (TPM) and input/output per second (IOPS).   Azure ..read more

As promised in the CFP for POSETTE: An Event for Postgres 2024, all of the talk selection decisions were emailed out on April 17th.  Our talk selection work has now concluded, with the possible exception of accepting proposals from the Reserve list.   So what’s next? First I want to thank all of you Postgres people who submitted such amazing talk proposals into the CFP for POSETTE, now in its 3rd year. I was so impressed by the submissions and wish we could have accepted more of them.   And I also want to thank Alicja Kucharczyk, Daniel Gustafsson, and Melanie Plageman from POSE ..read more

Welcome, Azure Community! March has been an exciting month for Azure Database for PostgreSQL Flexible Server, as we introduced many new features and improvements that greatly enhance how databases are managed and perform on Azure. Following a tradition of innovation and improvement, this month's updates bring even more capabilities to your database deployments, ensuring that your applications are more secure, efficient, and scalable. Let's explore the notable features that were launched in March 2024.   Highlights of the Month Migration Service in Azure Database for PostgreSQL (Ge ..read more

A common question in my discussions with architects and data scientists over the past few weeks has been “When will you have LangChain integration for Azure Database for PostgreSQL?” Thankfully, we already have that support today. Any of the examples published by LangChain for OSS PostgreSQL should work with our service as well. At the end of the day, Azure Database for PostgreSQL is running OSS PostgreSQL.   This post will be the first in a three-part blog series that will demonstrate how to use LangChain, Azure OpenAI, and Azure Database for PostgreSQL to chunk, embed, and query documen ..read more

The azure_ai extension on Azure Database for PostgreSQL now introduces in preview the ability to invoke machine learning models hosted on Azure Machine Learning online endpoints in real-time.    Azure Machine Learning supports end-end machine learning lifecycles from building and training models to Generative AI workflows with prompt-flow, and these learning models or pipelines can be hosted on fully managed endpoints for inferencing.  Online inferencing endpoints can host pre-trained or custom models that are trained and registered in the Azure Machine learning workspace ..read more

Greetings Azure Community! As we continue our journey into 2024, the momentum we gathered in January with Azure Database for PostgreSQL Flexible Server has not slowed down. February has been a month of substantial progress and exciting new features aimed at enhancing your PostgreSQL experience on Azure. We're thrilled to share the latest advancements that have been introduced this month, including significant version upgrades and enhanced logging features. Let’s dive into the updates and explore how they can benefit your PostgreSQL deployments on Azure. Feature Highlights of the Month:   ..read more

The azure_ai extension on Azure Database for PostgreSQL now has text translation capabilities, in preview, using Azure AI translator.   With the text translation APIs, you can translate text in more than 100 languages from right within SQL, which facilitates building intelligent multilingual applications on Azure Database for PostgreSQL. The translation is done in real time and translated text can be stored in a Postgres column for future references or can be used on the fly as a piece of data involved in the execution of a query. The extension also supports automatically detecting the la ..read more

PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.   The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 35 years of active development on the core platform.    Private Link Support in PostgreSQL Flexible Server Ever since Azure Database for PostgreSQL - Flexible Server went public years ago we have seen dramatic adop ..read more

This blog post is your essential guide to enhancing the speed and efficiency of your index creation process in Azure Database for PostgreSQL - Flexible Server databases. Discover a wealth of practical tips and strategies designed to streamline your approach to index management. From tuning server parameters for optimal performance to cleaning up excess space on tables.   You will see we ensure a smooth and efficient index creation experience. You will also be driven  into the importance of monitoring and resolving potential blockers that could hinder the index creation process, as we ..read more

Query tuning plays a crucial role pertaining to database performance. If you are facing issues with query run times while using a pattern search with LIKE or ILIKE operators, you are in the right place. This blog helps you with tuning the sub-optimal query plan which impacts the query performance with LIKE or ILIKE operators. In such scenarios a normal b-tree index may not generate an optimal query plan.   This blog will walk you through a use case scenario and show you how to tune your queries with LIKE or ILIKE operators. The Postgres Operator class and pg_trgm extension available on Az ..read more