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?
@mahmoudalsayed1138
2 жыл бұрын
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
@gbadeboakeem5456
2 жыл бұрын
When are you implementing AAD with flexible server? this option exist in Single server
@alicjakucharczyk4664
Жыл бұрын
it went GA 2 days ago
@mahmoudalsayed1138
2 жыл бұрын
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
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?
@mahmoudalsayed1138
2 жыл бұрын
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
@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
Пікірлер: 15