Skip to content

Top Best Ask Show New Jobs

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

(github.com)

58 pointsvishesh923y 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

7 comments · 4 top-level

fulafel3y ago· 2 in thread

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.

hu33y ago

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

faangsticle3y ago

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

sigg33y ago· 1 in thread

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.

vishesh92OP3y ago

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

chamik3y ago

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

jasfi3y ago

Nice section on MVCC in Postgres.

j / k navigate · click thread line to collapse