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.

Do check out the psql cheatsheet & queries directory. Those queries have saved me a lot of time and trouble during critical production issues.

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.

For Windows, if you run Docker Desktop using WSL2 integration, it is near native perf.

Just dont volume mount the data folder to the host and its fine

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.