Show HN: pg-primer - Beginner's guide to administering/managing PostgreSQL(github.com)

58 pointsby vishesh923 anni fa7 comments

Show HN: pg-primer - Beginner's guide to administering/managing PostgreSQL

https://github.com/vishesh92/pg-primer

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

4 comments

sigg33 anni fa

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.

vishesh923 anni fa

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

fulafel3 anni fa

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.

hu33 anni fa

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

faangsticle3 anni fa

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

chamik3 anni fa

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

jasfi3 anni fa

Nice section on MVCC in Postgres.