Azure Database for PostgreSQL

85 Blog Articles

Options

7,466

arunkumarthiags on 01-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? ...

1,685

Dandan_Zhang on 01-13-2021 10:25 AM

A troubleshooting checklist for how to investigate Postgres connection issues on Azure.

4,467

thomasmunro on 12-12-2020 09:47 AM

Collations are wonderful, but we often hear about them only when indexes break! PostgreSQL 14 makes collations better.

14.2K

clairegiordano on 12-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...

948

ramkychan on 12-01-2020 04:56 PM

Auto start/stop Flexible Server using Azure Automation Python RunBook

2,016

aritra17 on 11-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...

5,038

marcoslot on 11-21-2020 09:39 AM

Learn how stored procedures in Hyperscale (Citus) are now 9X faster using a special technique called distributed functio...

2,227

mk_sunitha on 11-16-2020 09:18 AM

Tips for using Azure CLI to improve productivity with the Flexible Server option (Preview) in Azure Database for Postgre...

1,178

Bashar-MSFT on 11-13-2020 11:14 AM

1,108

PedroAcevedo on 11-09-2020 12:01 PM

4,506

mahmoud-sakr on 11-09-2020 09:28 AM

How to analyze geospatial movement trajectories at scale with Postgres and the MobilityDB, PostGIS, & Citus extensions.

5,192

marcoslot on 10-29-2020 09:30 AM

Learn about the latest open source developments in pg_cron: The periodic job scheduler for PostgreSQL.

3,132

saisrirampur on 10-28-2020 09:55 AM

Learnings from migrating an analytics dashboard from Redshift to Hyperscale (Citus) on Azure Database for PostgreSQL.

28.8K

andresfreund on 10-25-2020 09:37 AM

Improving connection scalability in Postgres 14. From the neat to the gritty: snapshot scalability edition.

3,624

dimitrifontaine on 10-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...

35.6K

andresfreund on 10-08-2020 09:30 AM

Why it’s important to improve Postgres connection scalability, plus an analysis on the limits of connection scalability ...

9,193

Sunil_Agarwal on 10-03-2020 12:09 PM

A technical overview of the new Flexible Server option (now in Preview) in Azure Database for PostgreSQL.

6,781

Sunil Kamath on 09-22-2020 08:00 AM

Introducing the preview of a new deployment option, Flexible Server—bringing you more controls, confidence, and cost opt...

7,073

nilsdijk on 09-19-2020 09:43 AM

How we sped up percentile calculations for a customer by 45x using Postgres, Citus, and t-digest, without access to our ...

2,114

marcoslot on 09-16-2020 02:01 PM

Based on a Warsaw PostgreSQL Users Group talk, all about how Citus gives you Postgres at any scale. Includes a demo by o...

4,606

nazliugurkoyluoglu on 09-03-2020 11:49 PM

Story of how to use newly-released SQLancer to hunt for logic errors in databases using Ternary Logic Partitioning.

2,238

FranciscoPardillo on 08-25-2020 11:25 AM

Here you have an alternative way to alter a table column type based on an online migration using extra columns

3,646

FranciscoPardillo on 08-25-2020 11:24 AM

Examples of how to load data with Postgres COPY

3,062

mksunitha on 08-03-2020 10:50 PM

You can find Bitnami Certified Apps (“templates”) for Postgres on the Azure Marketplace. These templates are one-click s...

7,270

j-davis on 07-28-2020 08:51 AM

SCRAM with channel binding is a much more secure type of password authentication vs. traditional techniques such as md5 ...

3,033

korhan-ileri on 07-23-2020 07:25 PM

Tracking bloat in your Azure Database for PostgreSQL database is easy with custom metrics, Datadog, & this how-to post. ...

3,409

Sudheesh_N on 07-22-2020 04:46 PM

Don't keep credentials in your code - use a managed identity instead

2,489

zukoweh on 07-10-2020 10:12 AM

Security & compliance certificates on Azure Database for PostgreSQL—from HIPAA to PCI to SOC, and everything in between

2,257

Roland Lee on 07-02-2020 09:07 AM

Reduce backend connections to support high scale user counts

6,833

colton17 on 06-26-2020 09:45 AM

This is how we converted 2 billion Postgres rows from INT to BIGINT that were part of a primary key with 20 minutes of d...

Latest Comments

in Evolving pg_cron together: Postgres 13, audit log, background workers, & job names on 01-18-2021

So uh, are you going to add pg_cron to Azure for postgres 12?

0 Likes

in New Oracle to Postgres Migration Guide for Azure on 01-16-2021

Great resources Arun.

1 Likes

in Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL on 01-14-2021

In fact we have the experience that pgbouncer need quite some cpu and can't utilize more than a core , so if you think about running having e.g. 60 k8 pods clients each with 30 max connection's you need to have several pgbouncer instances running to utilize an underlying vm with several cores.Pgboun...

0 Likes

in Change data capture in Postgres: How to use logical decoding and wal2json on 01-13-2021

Brent - The idea of consumer is to ingest changes in the database in a neutral format like JSON. The Consumer can then send the data to any target. For example, in this PGConf.EU presentation Webedia uses a custom service called walparser to convert wal2json’s output into MQ messages, then sends the...

0 Likes

in Change data capture in Postgres: How to use logical decoding and wal2json on 01-11-2021

So MS Azure PostgreSQL can act as a producer but not as a consumer of the slot output? Only native PostgreSQL can act as a consumer? Is that correct? Thanks.

0 Likes