3 ms·
We were well into implementation of a SaaS that relied on PG and used their cloud offering before we found that the latency was just abysmal. The best we could
by thrixton 6y ago
We were well into implementation of a SaaS that relied on PG and used their cloud offering before we found that the latency was just abysmal.
The best we could get was ~45ms using pgbench vs ~10ms local and ~18 using AWS Aurora.
Their solution, wait for the flexible server offering which is not available in AUS but when tested in another region showed ~30ms so still not fit for purpose.
We eventually had to switch to running PG in AKS which has its pros and cons.
The funniest thing was, running Azure VM to AWS PG was faster than running Azure VM to Azure PG.