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.