cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Database for PostgreSQL Blog
Options
495

Online Migration to PostgreSQL Flexible Server on Azure from Single Server

hariramt on Apr 17 2024 02:48 PM
  You can leverage PostgreSQL's online migration feature for seamless database transitions, ensuring minimal downtime du...
872

General availability of enhanced Geo-Disaster recovery with read replicas

AlicjaKucharczyk on Apr 16 2024 10:25 AM
General availability of virtual endpoints and promote to primary server action
4,467

March 2024 Recap: Azure PostgreSQL Flexible Server

varun-dhawan on Apr 09 2024 10:09 AM
March 2024 Feature Recap: Azure PostgreSQL Flexible Server - New Features and Enhancements
1,377

LangChain integration with Azure Database for PostgreSQL (Part 1)

JoshMSFT on Apr 02 2024 02:10 PM
Use LangChain to split documents into smaller chunks, generate embeddings for each chunk using Azure OpenAI, and store t...
1,529

The serverless frontier: Announcing Azure's dual-peak serverless regions on Kilimanjaro

AlicjaKucharczyk on Apr 01 2024 02:20 AM
Scaling the Clouds: Microsoft's Serverless Adventure on Kilimanjaro's Twin Peaks
1,270

Real-time predictions with the azure_ai extension (Preview)

Denzil Ribeiro on Mar 26 2024 09:50 PM
real-time ml predictions azure_ai Get real-time low latency machine learning model predictions with a single SQL functio...
2,209

Calling Postgres speakers, POSETTE CFP is open until Apr 7th 2024

clairegiordano on Mar 22 2024 01:07 PM
Call for Proposals (CFP) is open til Sun Apr 7 at 11:59pm PDT for POSETTE: An Event for Postgres, a free & virtual event...
9,312

February 2024 Recap: Azure PostgreSQL Flexible Server

varun-dhawan on Mar 20 2024 06:22 AM
February 2024 Feature Recap: Azure PostgreSQL Flexible Server - New Features and Enhancements
3,352

Real-time text translation using the azure_ai extension in Azure Database for PostgreSQL

Denzil Ribeiro on Mar 19 2024 07:34 PM
Text translations to 100+ languages in real-time made possible with azure_ai extension for Azure Database for PostgreSQL
2,099

Private Link based networking is now generally available in Azure PostgreSQL Flexible Server

Gennadyk on Mar 19 2024 08:00 AM
Today, we are proud to announce General Availability for Private Link based networking feature in Azure Database for Pos...
1,513

PostgreSQL Making Index creation faster

Gayathri_Paderla on Mar 05 2024 08:38 AM
Best practices for creating PostgreSQL indexes to make the creation process faster.
1,942

Tips for tuning Postgres LIKE & ILIKE queries via pg_trgm on Azure

Sarat_Balijepalli on Mar 04 2024 09:54 AM
Tips to improve query performance when using pattern search with LIKE or ILIKE operators by using apt Indexing.
3,295

What’s in a name? Hello POSETTE: An Event for Postgres 2024

clairegiordano on Mar 01 2024 01:27 PM
What does POSETTE stand for? And what exactly is POSETTE: An Event for Postgres? (Hint: it’s free & virtual.)
1,369

Podcast about transitioning from developer to PostgreSQL specialist, with Derk van Veen

techieari on Feb 28 2024 09:32 AM
Fave bits from this podcast episode Postgres and Derk’s transition from Java developer to Postgres specialist.
3,202

The azure_ai extension to Azure Database for PostgreSQL, definition and demo

clairegiordano on Feb 27 2024 10:43 AM
What you need to know about this demo of the new azure_ai extension to Azure Database for PostgreSQL – Flexible Server.
8,447

What’s new in the Postgres 16 query planner / optimizer

David_Rowley on Feb 08 2024 10:07 AM
Postgres 16 improves the query planner to make many SQL queries run faster than on previous versions of Postgres.
10.1K

January 2024 Recap: Azure PostgreSQL Flexible Server

varun-dhawan on Feb 05 2024 07:21 AM
January 2024 Feature Recap: Azure PostgreSQL Flexible Server Updates: New Features and Enhancements.
1,517

Podcast highlights on benchmarking Postgres performance, from Path To Citus Con Episode 11

Aaron Wislang on Feb 02 2024 01:43 PM
Highlights from Episode 11 about Postgres benchmarking, with engineers Jelte Fennema-Nio and Marco Slot.
2,624

Harness the Power of the Migration Service in Azure Database for PostgreSQL

adityaduvuri on Jan 30 2024 01:03 AM
Modernize with ease, streamline PostgreSQL migrations to Azure.
4,832

Advanced Monitoring for PostgreSQL Using Log Analytics

varun-dhawan on Jan 22 2024 03:15 PM
This blog discusses how to use Azure Log Analytics for monitoring and alerting on a large fleet Azure Postgres servers.
2,536

Seamless Shift: Migrating from Amazon RDS for PostgreSQL to Azure Database for PostgreSQL

gyanisinha on Jan 15 2024 05:59 AM
A step-by-step game plan for seamless migration from Amazon RDS for PostgreSQL to Azure Database for PostgreSQL
1,742

Highlights from podcast episode about Postgres monitoring with Lukas Fittl and Rob Treat

techieari on Dec 15 2023 12:50 PM
Highlights from the latest Path To Citus Con episode with Lukas, Rob, Claire, and Pino all about PostgreSQL monitoring.
2,439

Enhance your Azure PostgreSQL Flexible Server security posture with Azure Defender

Gennadyk on Dec 13 2023 08:01 AM
Announcing Azure Defender for Cloud support with Microsoft Azure Database for PostgreSQL - Flexible Server
8,934

November 2023 Recap: Azure PostgreSQL Flexible Server

varun-dhawan on Dec 06 2023 08:27 AM
November 2023 Azure Database for PostgreSQL Flexible Server Updates: New Features and Enhancements.
2,302

My Illustrated Guide to Postgres at PASS Data Summit 2023

clairegiordano on Dec 01 2023 12:06 PM
This illustrated guide to my first-timer Postgres experience at PASS Data Community Summit 2023 is a show and tell of wh...
2,801

Mastering the Move: Migrating from Azure Database for PostgreSQL Single to Flexible Server

hitakagi on Dec 01 2023 06:57 AM
Migrate from Azure PostgreSQL - Single to Flexible Server: Key steps for a seamless transition.
5,215

Enhance Monitoring with Azure Postgres Grafana Dashboard

varun-dhawan on Nov 30 2023 10:31 AM
Enhancing Monitoring: Introducing the New Grafana Dashboard Integration.
6,405

Azure Database for PostgreSQL: AI-Ready for Enterprise Applications in Flexible Server

charlesfeddersenMS on Nov 15 2023 08:00 AM
Your guide to the 11 new features announced at Microsoft Ignite 2023 for Azure Database for PostgreSQL – Flexible Server...
2,658

Multi-Region Disaster Recovery: Streamlined with New Features

AlicjaKucharczyk on Nov 15 2023 08:00 AM
Multi region disaster recovery in Azure PostgreSQL Elevate your disaster recovery strategy with new public preview featu...
5,267

General Availability of PostgreSQL 16 on Azure Database for PostgreSQL - Flexible Server

AlicjaKucharczyk on Nov 15 2023 08:00 AM
PostgreSQL16-new-features PostgreSQL 16 is now generally available on Azure Database for PostgreSQL - Flexible Server.

Latest Comments

Sivanesan-KMS
in Connect from Function app with managed identity to Azure Database for PostgreSQL on Apr 15 2024 06:04 AM
Do we have any updated document for flexible server.
0 Likes
jddhanush
in Auto start/stop Flexible Server using Azure Automation Python RunBook on Mar 24 2024 10:35 PM
Hi @ramkychan , We have already implemented the auto start/stop on our server. Today our server does not start automatically. where I will check the issue.
0 Likes
juanjocruzcruz
in Automate Backups from Azure Database for PostgreSQL Server to Azure Storage for Long Term Retention on Mar 22 2024 03:08 AM
Hola Pedro, saludos desde España ;)He seguido el procedimiento tal cual y funciona perfectamente a excepción de: az vm deallocate Lo hace bien la primera vez cuando he hecho el az login, pero al apagarse la VM al día siguiente ya no me lo hace. En el log me dice justamente eso: Un saludo,
0 Likes
Gayathri_Paderla
in PostgreSQL Making Index creation faster on Mar 11 2024 12:50 PM
Thank you for reviewing the article. It's important to note that there are multiple methods available for calculating bloat, and in this article, I have opted for this specific formula.
0 Likes
Srinuvas
in PostgreSQL Making Index creation faster on Mar 06 2024 08:30 AM
Hi Gayathri, Thank you for sharing the info. The calculation for dead_pct should be (n_dead_tup::float / (n_live_tup + n_dead_tup)) * 100.
0 Likes