Show HN: pg-primer - Beginner's guide to administering/managing PostgreSQL (opens in new tab)

(github.com)

58 pointsvishesh922y ago7 comments

I created this small guide for people starting with postgresql. I added some queries I commonly used as well. Any feedback?

7 comments

sigg32y ago

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.

vishesh92OP2y ago

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

fulafel2y ago

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.

hu32y ago

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

faangsticle2y ago

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

chamik2y ago

Very well written! I don't have a lot of experience managing Postgres, this gave me a good insight.

jasfi2y ago

Nice section on MVCC in Postgres.

j / k navigate · click thread line to collapse