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

  • 99 Blog Articles
Options
988

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.
8,803

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.
1,384

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.
2,532

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)
2,096

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.
7,087

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.
4,120

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...
3,879

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.
6,427

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.
3,507

Citus Tips for Postgres: How to alter distribution key, shard count, & more

halilozanakgul on May 03 2021 09:26 AM
How to change your distribution column, shard count, colocation, & access method with Hyperscale (Citus)
5,885

Sharding Postgres with Basic tier in Hyperscale (Citus), how why & when

onderkalaci on Apr 17 2021 09:39 AM
Basic tier makes it easy to get started with Hyperscale (Citus) & easy to adopt a distributed data model from the beginn...
10.4K

Speeding up recovery and VACUUM in Postgres 14

David_Rowley on Mar 25 2021 10:33 AM
Part of our Postgres Committers series, a dive into improvements in Postgres 14 that speed up vacuum & recovery.
3,610

Why Restarting Azure Database for PostgreSQL took long?

Bashar-MSFT on Feb 22 2021 01:16 PM
Do you know what happens when Azure Database for PostgreSQL restart? Read this blog post to learn more about restart ope...
6,696

Faster Data Migrations in Postgres

saisrirampur on Feb 20 2021 09:50 AM
How to speed up Postgres database migrations using pg_dump, pg_restore, and python scripts such as Parallel Loader.
9,605

Migrating database storage objects from Oracle to Postgres

arunkumarthiags on Feb 08 2021 09:56 AM
Do you know the best practices to migrate database storage objects such as tables, indexes, etc. from Oracle to Postgres...
4,368

Citus Tips: How to undistribute a distributed Postgres table

halilozanakgul on Feb 06 2021 09:44 AM
How the new undistribute_table() feature in Citus 9.5 makes it easier to experiment with Citus when scaling out Postgres...
15.8K

New Oracle to Postgres Migration Guide for Azure

arunkumarthiags on Jan 15 2021 09:55 AM
Have you wondered what it takes to migrate an Oracle workload to Azure Database for PostgreSQL and be successful at it? ...
4,526

Are you running into Postgres connection issues on Azure?

Dandan_Zhang on Jan 13 2021 10:25 AM
A troubleshooting checklist for how to investigate Postgres connection issues on Azure.
6,663

Don't let collation versions corrupt your PostgreSQL indexes

thomasmunro on Dec 12 2020 09:47 AM
Collations are wonderful, but we often hear about them only when indexes break! See how PostgreSQL can make collations b...
17.7K

When to use Hyperscale (Citus) to scale out Postgres

clairegiordano on Dec 05 2020 09:39 AM
One of the most common questions we get: when to use Hyperscale (Citus)? What use cases are a fit for scaling out Postgr...
2,109

Auto start/stop Flexible Server using Azure Automation Python RunBook

ramkychan on Dec 01 2020 04:56 PM
Auto start/stop Flexible Server using Azure Automation Python RunBook
2,520

Azure CLI improvements for Azure Database for PostgreSQL – Single server

aritra17 on Nov 24 2020 01:17 PM
With the new changes to the Azure CLI, building applications has become much easier. This blog post walks you through ke...
6,797

Making Postgres stored procedures 9X faster in Citus

marcoslot on Nov 21 2020 09:39 AM
Learn how stored procedures in Hyperscale (Citus) are now 9X faster using a special technique called distributed functio...
2,850

Azure CLI & Flexible Server for Postgres: Better Together

mk_sunitha on Nov 16 2020 09:18 AM
Tips for using Azure CLI to improve productivity with the Flexible Server option (Preview) in Azure Database for Postgre...
5,717

Analyzing GPS trajectories at scale with Postgres, MobilityDB, & Citus

mahmoud-sakr on Nov 09 2020 09:28 AM
How to analyze geospatial movement trajectories at scale with Postgres and the MobilityDB, PostGIS, & Citus extensions.
7,832

Evolving pg_cron together: Postgres 13, audit log, background workers, & job names

marcoslot on Oct 29 2020 09:30 AM
Learn about the latest open source developments in pg_cron: The periodic job scheduler for PostgreSQL.
4,280

Migrating interactive analytics apps from Redshift to Postgres, ft. Hyperscale (Citus)

saisrirampur on Oct 28 2020 09:55 AM
Learnings from migrating an analytics dashboard from Redshift to Hyperscale (Citus) on Azure Database for PostgreSQL.
33.9K

Improving Postgres Connection Scalability: Snapshots

andresfreund on Oct 25 2020 09:37 AM
Improving connection scalability in Postgres 14. From the neat to the gritty: snapshot scalability edition.
4,634

What’s new in pg_auto_failover 1.4 for Postgres high availability

dimitrifontaine on Oct 08 2020 09:28 PM
All about what’s new in pg_auto_failover 1.4, an open source extension to Postgres for high availability & automated fai...

Latest Comments

screig
in When to use Hyperscale (Citus) to scale out Postgres on Oct 14 2021 11:36 AM
Hi Nik Thanks for your reply but again I don't think this is quite accurate, as you can see I an actual user cannot upgrade to 14. (from my portal view) Also I did try to update last week (just one step v11->v12) however this did not work. We lost the db for eight hours, we could not restore it, we ...
0 Likes
Nik_Larin_Azure_Data
in When to use Hyperscale (Citus) to scale out Postgres on Oct 14 2021 09:36 AM
@screig, good points. We've been working on radical improvements in these important areas. 1. We added in-place Postgres version upgrade to Hyperscale (Citus) when we introduced more than one major Postgres versions. You can initiate Postgres upgrade by clicking the 'Upgrade' button in 'Overview' pa...
0 Likes
Sudheesh_N
in Connect from Function app with managed identity to Azure Database for PostgreSQL on Sep 17 2021 11:02 AM
@alfreema , I just checked and confirmed that is not the case. Pasting below the snapshot taken. Logically All Application should show all types . I am not sure why you are unable to see when you select all applications.
0 Likes
alfreema
in Connect from Function app with managed identity to Azure Database for PostgreSQL on Sep 17 2021 09:14 AM
@Sudheesh_N it doesn't for me. I confirmed that before posting my comment above.
0 Likes
Sudheesh_N
in Connect from Function app with managed identity to Azure Database for PostgreSQL on Sep 17 2021 07:31 AM
@alfreema Thank you for the fe4edback. That filter item was introduced now. The current one of All Applications should also help to display the managed identity
0 Likes