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

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

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.