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

[@octaverossi3428]

great video, clear concise & sumup. Thanks!

[@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

[@1464pokemon]

very informative session, thank you very much

[@gbadeboakeem5456]

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

[@alicjakucharczyk4664]

it went GA 2 days ago

[@berndeckenfels]

Why is flexible slower than the same VM, where is the overhead coming from? Does it use the local disk for temporary tables and scratch space automatically?

[@opiee1999]

Great information

[@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

[@jayaprakashs1526]

It doesn't have the cross region replication which is really dangerous part if any problem occurs with same region hosting.

[@alicjakucharczyk4664]

cross region replication is already in public preview and GA is coming soon

[@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"?

[@syedtufailzada9858]

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?

[@nutsackmania]

I choose it because it doesn't have the read replica feature publicly available--who would ever use that?!

[@alicjakucharczyk4664]

it has now in the public preview, GA will come soon