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
1,133

Lower your total cost of ownership with Azure Database for PostgreSQL

kelloconn on Aug 11 2022 03:26 PM
The Enterprise Strategy Group (ESG) conducted an economic value study on the top-level benefits and cost savings that bu...
3,404

Debugging Postgres autovacuum problems: 13 tips

samay_sharma on Jul 28 2022 09:03 AM
The definitive post for optimizing Postgres autovacuum, along with 13 tips on how to fix the most common vacuum issues.
1,472

Single to Flexible server PostgreSQL migration tool is now in Preview!

sridrang on Jul 27 2022 10:17 AM
Learn about migrating your Single Server to Flexible Server PostgreSQL seamlessly using a new in-line migration tool.
1,104

Introducing support for Pgrouting and PLV8 extensions in PostgreSQL Flexible Server

Gennadyk on Jul 07 2022 07:53 PM
Introducing support for pgrouting and plv8 extensions in Azure PostgreSQL Flexible Server.
1,658

PostgreSQL v14 is now available in Flexible Server PostgreSQL!

sridrang on Jun 30 2022 12:44 PM
You can now deploy PostgreSQL version 14 on Azure Database for PostgreSQL Flexible Server!
1,921

Achieve high uptime with Flexible Server PostgreSQL HA!

sridrang on Jun 20 2022 04:57 PM
Learn about high availability deployment models, new HA capabilities, and how to achieve high uptime with Azure Database...
3,454

Building IoT apps using Postgres, Citus, and Azure

Manjunath_Suryanarayana on Jun 14 2022 10:29 AM
Learn about a reference architecture for building scalable IoT time-series apps with Postgres, Citus, and Azure.
3,635

Secure your Java application connections to Flexible Server via JDBC and SSL

Gennadyk on May 27 2022 08:24 AM
Postgres Flexible Server on Azure requires secure connection by default. In this post, we will explain to you how to set...
12.7K

Speeding up sort performance in Postgres 15

David_Rowley on May 19 2022 09:28 AM
All about the sort performance gains in the upcoming PostgreSQL 15 open source release.
4,989

Moving Postgres data 26X faster with Azure Data Factory

halilozanakgul on May 17 2022 09:23 AM
All about new ADF features for moving data to or from Postgres on Azure, that speed up both reads and writes.
4,371

How to benchmark performance of Citus and Postgres with HammerDB on Azure

JelteF on Mar 12 2022 09:50 AM
Deep dive into database performance benchmarks, including sample benchmark results for Citus and Postgres on Azure.
2,467

Introducing ability to allow-list extensions in PostgreSQL Flexible Server

Gennadyk on Feb 27 2022 04:53 PM
Introducing allow-listing extensions using azure.extensions server parameter in Azure PostgreSQL Flexible Server. As add...
1,822

Call for speakers for Citus Con: An Event for Postgres

clairegiordano on Jan 31 2022 09:34 AM
The CFP is open until Feb 6, 2022 for Citus Con: An Event for Postgres—a free and virtual developer event.
2,384

Why give a conference talk (or, why give a Postgres talk)

clairegiordano on Jan 11 2022 10:31 AM
How giving a talk at a Postgres event can benefit the Postgres community—and also you, your team, & your project.
2,307

Deploy a connectivity dashboard for PostgreSQL Flexible Server

seernu on Jan 06 2022 07:05 PM
How to deploy and use a dashboard to monitor connectivity patterns in Azure Database for PostgreSQL Flexible Server.
2,676

Create a Connectivity Dashboard for Postgres Single Server in Azure

seernu on Dec 18 2021 06:04 PM
Deploy using ARM template or manually create a dashboard to monitor connectivity patterns in PostgreSQL - Single Server ...
79.8K

UK COVID-19 dashboard built using Postgres and Citus for millions of users

clairegiordano on Dec 11 2021 09:48 AM
Why and how the UK Coronavirus Dashboard team built their analytics service on top of PostgreSQL & Citus on Azure.
13K

Azure Database for PostgreSQL – Flexible Server is now GA!

Sunil Kamath on Nov 30 2021 08:00 AM
We're extremely excited to announce General Availability (GA) of Azure Database for PostgreSQL – Flexible Server in more...
6,423

Private Networking Patterns in Azure Database for Postgres Flexible Server

Gennadyk on Nov 29 2021 01:59 PM
Understanding networking architecture is crucial when deploying Flexible Server in your enterprise Azure footprint.
4,834

Introducing Private Link in Hyperscale (Citus) for Postgres on Azure

rongxunwang on Nov 06 2021 10:14 AM
How to use private link (preview) in Hyperscale (Citus) in Azure Database for PostgreSQL to connect securely & privately...
6,311

Memory Tuning for workloads in PostgreSQL Flexible Server on Azure

Gennadyk on Oct 21 2021 11:04 AM
Delve into Postgres memory architecture and discuss some of the memory related global parameters you may want to tune.
3,667

Flexible Server now supports V4 compute series in PostgreSQL on Azure

sridrang on Oct 13 2021 09:29 AM
News on compute sizes: Flexible Server supports the V4 series (Ddsv4/Edsv4), giving your workloads a performance boost.
13.3K

How We Shipped PostgreSQL 14 on Azure Within One Day of its Release

ozgune on Oct 01 2021 04:09 PM
How we made Postgres 14 available in production on Azure in Hyperscale (Citus) just 1 day from the PG14 release.
2,674

Shard rebalancing in the Citus 10.1 extension to Postgres

JelteF on Sep 03 2021 09:51 AM
How to monitor the progress of the Citus shard rebalancer, new as of Citus 10.1. Plus performance optimizations.
3,925

Citus 10 is now GA in Hyperscale (Citus) for Postgres on Azure

Nik_Larin_Azure_Data on Aug 10 2021 09:13 AM
Good news: Citus 10, Postgres 13, columnar storage, Basic tier, and more features are now GA in Hyperscale (Citus)
7,129

DNS configuration patterns for Azure Database for PostgreSQL - Flexible Server

Gennadyk on Jul 22 2021 10:32 AM
In this blog we will go through common DNS configuration options with Azure Database for PostgreSQL – Flexible Server.
8,415

What’s new in Hyperscale (Citus) for Postgres on Azure (ft. read replicas)

Nik_Larin_Azure_Data on May 29 2021 09:38 AM
About all the ways we’ve made it easier to try & use the Hyperscale (Citus) option in Azure Database for PostgreSQL.
5,628

Bringing the best of Azure and PostgreSQL innovation to developers

Sunil Kamath on May 24 2021 08:50 PM
This week at Microsoft Build, we are announcing some exciting new capabilities, offers, and features that make it easier...
5,949

Postgres with columnar compression in Hyperscale (Citus) on Azure

j-davis on May 22 2021 09:40 AM
How to use the columnar feature in Hyperscale (Citus) to compress Postgres tables, reduce IO, & speed up queries.
7,742

New Postgres superpowers in Hyperscale (Citus) with Citus 10

marcoslot on May 08 2021 09:44 AM
All about new Citus 10 features that are now in preview in Hyperscale (Citus) in Azure Database for PostgreSQL.

Latest Comments

samay_sharma
in Debugging Postgres autovacuum problems: 13 tips on Jul 29 2022 10:43 AM
Hey @Kibo_Jay_Zmudka : Glad to hear that you were able to find and solve the issue! Thanks for your comment - it started my day with a smile :)
1 Likes
Kibo_Jay_Zmudka
in Debugging Postgres autovacuum problems: 13 tips on Jul 29 2022 08:22 AM
Thank-you so much Samay! This helped me solve a stubborn problem we were having with a postgres query. The catalog files were bloated and were constantly being autovacuumed. Turns out we had a replication slot sitting there that was no longer being used.
1 Likes
Rashmi_Mysore
in Building IoT apps using Postgres, Citus, and Azure on Jun 15 2022 12:04 AM
This is interesting. 
2 Likes
usmankhawar
in Backup Azure Database for PostgreSQL to a Blob Storage on Jun 06 2022 03:39 AM
How to take backup like this when the PostgresServer is within Virtual network?(It doesn't allow connecting via Azure CLI)
0 Likes
Sunil_Agarwal
in What is Flexible Server in Azure Database for PostgreSQL? on Jun 02 2022 04:38 PM
Oliver - it should be in minutes. Essentially the time taken is to run the recovery. Assume the maintenance window chosen is low activity window, it should be couple of minutes
0 Likes