3 ms·
Pretty solid advice, nice article. One thing: > For example, on my (pretty average) workstation, I can do ca. 25k simple read transactions per 1 CPU core on a
by isoprophlex 6y ago
Pretty solid advice, nice article.
One thing:
> For example, on my (pretty average) workstation, I can do ca. 25k simple read transactions per 1 CPU core on an “in memory” pgbench dataset…with the default config for Postgres v13!
Forget about reaching those numbers on managed DB-as-a-service instances, specifically Azure managed postgres. In my experience these have comparatively poor peak performance, with high variability in latency to boot.
Bare metal all the way, if you can spare the allocation of a dedicated DBA.
Also... if rapid reads and steady performance is what you're after, provision a replica for the occasional analytical workloads.
- samf 6y agoGood info; I came here looking for experience with managed databases. Does anyone have experience with managed instances on other platforms?