Top 10 reasons to choose Flexible Server for Azure Database for PostgreSQL

Top 10 reasons to choose Flexible Server for Azure Database for PostgreSQL | Citus Con 2022

Рет қаралды 4,748

Күн бұрын

Video of talk by Sunil Agarwal at Citus Con: An Event for Postgres. Abstract: The newly GA’d Azure Database for PostgreSQL managed service is called “Flexible Server” but what does that mean? What is the new “Flexible Server” option for Postgres and why should you care? In this talk from the one of the Azure Database for PostgreSQL product experts at Microsoft, you’ll walk through a high-level overview of the architecture and the 10 reasons to choose Flexible Server for Postgres on Azure.
What are the 10 reasons to consider Flexible Server? This talk covers Flexible Server’s relationship with Linux, lower latency, performance, zone resilient HA, custom maintenance window, lower cost, on-demand stop/start, built-in connection pooling, richer control of server configuration and telemetry. Spoiler alert: Flexible Server shows very comparable performance for PostgreSQL workloads migrated from on-premises/VMs, while also taking the operational complexity out of your equation by running on a managed service.
Sunil Agarwal has 30+ years of industry experience in databases. Today, Sunil leads the product team for the Azure Database for PostgreSQL managed service. Previously, Sunil worked as developer/lead building relational database engine technology, as a tool designer/lead building backup/restore tools, as an application developer/manager enabling B2B commerce and e-learning.
► Video bookmarks:
⏩ 00:00 Introduction
⏩ 00:56 1: Linux VM
⏩ 01:32 2: Premium managed storage
⏩ 02:28 3: Zone redundant backup storage
⏩ 05:50 4: High Availability
⏩ 06:57 5: Performance
⏩ 12:00 6: Smart defaults
⏩ 15:26 7: Planned maintenance control
⏩ 17:00 8: More server parameter control
⏩ 19:10 9: Built-in PgBouncer
⏩ 21:33 10: Cost Optimization
⏩ 23:58 Recap
⏩ 21:33 10: Cost Optimization
✅ Learn more:
Watch more Citus Con talks: aka.ms/cituscon-playlist
📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: aka.ms/cituscon
📌 Let’s connect:
Twitter - @CitusCon, / cituscon
#CitusCon #PostgreSQL #AzureDBPostgres

Пікірлер: 13

@1464pokemon Жыл бұрын

very informative session, thank you very much

@opiee1999 Жыл бұрын

Great information

@mahmoudalsayed1138 Жыл бұрын

Does this mean, Single server is hosted on Windows?!! The local storage is nice to know though! Thanks for the lecture!

@alicjakucharczyk4664 Жыл бұрын

yes, it does :) or more windows-like system

@syedtufailzada9858 2 жыл бұрын

Hi, you mentioned first that the performance is higher than vm but as shown in the slides the vm TPS are higher than azure flexible server for postgres?

@gbadeboakeem5456 Жыл бұрын

When are you implementing AAD with flexible server? this option exist in Single server

@alicjakucharczyk4664 Жыл бұрын

it went GA 2 days ago

@mahmoudalsayed1138 Жыл бұрын

Is the Burstable same concept as "Spot instance" on VM world? Also what would be the difference between a memory optimized Flexible server and a memory optimized Single server? Wouldn't both have this "local cache"?

@mahmoudalsayed1138 Жыл бұрын

Also it would be nice to mention what kind of queries has been used to benchmark the database? I mean if you do `select (1)` it is going to yield +1000 TPS but if you are doing something like `select * from table where c1=@p1 and c2=@p2` on a table with at least 5 columns and +2 million rows and you have two one index on c1,c2 then you could get more accurate metrics that reflects day to day use cases more accurately Other kind of benchmarks are not accurate and provide no insights on the actual performance of the DB server