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?
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
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"?
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?
great video, clear concise & sumup. Thanks!
very informative session, thank you very much
Great information
Does this mean, Single server is hosted on Windows?!!
The local storage is nice to know though!
Thanks for the lecture!
yes, it does :) or more windows-like system
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?
When are you implementing AAD with flexible server? this option exist in Single server
it went GA 2 days ago
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
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"?
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?
It doesn't have the cross region replication which is really dangerous part if any problem occurs with same region hosting.
cross region replication is already in public preview and GA is coming soon
I choose it because it doesn't have the read replica feature publicly available--who would ever use that?!
it has now in the public preview, GA will come soon