Show HN: pg-primer - Beginner's guide to administering/managing PostgreSQL (github.com) 58 points by vishesh92 3y ago ↗ HN I created this small guide for people starting with postgresql. I added some queries I commonly used as well. Any feedback?
[–] sigg3 3y 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. [–] vishesh92 3y ago ↗ Do check out the psql cheatsheet & queries directory. Those queries have saved me a lot of time and trouble during critical production issues.
[–] vishesh92 3y ago ↗ Do check out the psql cheatsheet & queries directory. Those queries have saved me a lot of time and trouble during critical production issues.
[–] chamik 3y ago ↗ Very well written! I don't have a lot of experience managing Postgres, this gave me a good insight.
[–] fulafel 3y 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. [–] hu3 3y ago ↗ For Windows, if you run Docker Desktop using WSL2 integration, it is near native perf. [–] faangsticle 3y ago ↗ Just dont volume mount the data folder to the host and its fine
[–] hu3 3y ago ↗ For Windows, if you run Docker Desktop using WSL2 integration, it is near native perf.
7 comments
[ 1.7 ms ] story [ 25.8 ms ] thread