Azure Database for PostgreSQL

94 Blog Articles

Options

6,260

Nik_Larin_Azure_Data on 05-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.

3,372

Sunil Kamath on 05-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,088

j-davis on 05-22-2021 09:40 AM

How to use the columnar feature in Hyperscale (Citus) to compress Postgres tables, reduce IO, & speed up queries.

5,797

marcoslot on 05-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,079

halilozanakgul on 05-03-2021 09:26 AM

How to change your distribution column, shard count, colocation, & access method with Hyperscale (Citus)

4,980

onderkalaci on 04-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...

9,418

David_Rowley on 03-25-2021 10:33 AM

Part of our Postgres Committers series, a dive into improvements in Postgres 14 that speed up vacuum & recovery.

2,749

Bashar-MSFT on 02-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...

5,839

saisrirampur on 02-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,037

arunkumarthiags on 02-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...

3,968

halilozanakgul on 02-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...

13.3K

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? ...

3,118

Dandan_Zhang on 01-13-2021 10:25 AM

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

6,067

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.

16.7K

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

1,609

ramkychan on 12-01-2020 04:56 PM

Auto start/stop Flexible Server using Azure Automation Python RunBook

2,344

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

6,267

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,609

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,871

PedroAcevedo on 11-09-2020 12:01 PM

5,249

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.

6,722

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,848

saisrirampur on 10-28-2020 09:55 AM

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

32.2K

andresfreund on 10-25-2020 09:37 AM

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

4,242

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

39K

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

11.8K

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.

8,258

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

8,574

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,528

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

Latest Comments

in Bringing the best of Azure and PostgreSQL innovation to developers on 06-04-2021

Happy to hear about all new features :beaming_face_with_smiling_eyes:,when will PostgreSQL Flexible Server be GA ?

0 Likes

in Postgres with columnar compression in Hyperscale (Citus) on Azure on 05-23-2021

Thank you @j-davis for Sharing this awesome blogpost

2 Likes

in Introducing Azure Active Directory authentication for Azure Database for PostgreSQL on 05-06-2021

Any suggestions for making the user experience here better for non cli tools (especially power query)?We have non-technical users who connect to the database through excel/odbc, or Power BIIn an ideal world, you'd integrate the credential exchange into the opensource drivers :)))

0 Likes

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

or any other alternative for backup using pg_cron

0 Likes

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

How could i achieve pg_dump using pg_cron?need to run pg_dump postgres > temp.sql -U postgres using pg_cron

0 Likes