What's the postgres IO performance under emulated Docker (ie docker desktop for win / mac os) like these days? A while ago it was slow enough that experiments involving performance conclusions might be better run with the native ports.
Very well written! I don't have a lot of experience managing Postgres, this gave me a good insight.
Nice section on MVCC in Postgres.
Cheers, mate! I just committed to using Postgres for a project at work, and apart from an SQL syntax bootcamp it's uncharted territory to me.