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

58 points by vishesh92 2 years ago | 7 comments
I created this small guide for people starting with postgresql. I added some queries I commonly used as well. Any feedback?
  • sigg3 2 years 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 2 years ago
      Do check out the psql cheatsheet & queries directory. Those queries have saved me a lot of time and trouble during critical production issues.
    • fulafel 2 years 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 2 years ago
        For Windows, if you run Docker Desktop using WSL2 integration, it is near native perf.
        • faangsticle 2 years ago
          Just dont volume mount the data folder to the host and its fine
        • chamik 2 years ago
          Very well written! I don't have a lot of experience managing Postgres, this gave me a good insight.
          • jasfi 2 years ago
            Nice section on MVCC in Postgres.