Show HN: pg-primer - Beginner's guide to administering/managing PostgreSQL • Hacker News Board

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

#1

Post by vishesh92 » Tue, Jun 20, 2023, 7:36 PM UTC

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

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

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

#2

Post by jasfi » Wed, Jun 21, 2023, 6:43 AM UTC

Nice section on MVCC in Postgres.

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

#3

Post by sigg3 » Wed, Jun 21, 2023, 8:35 AM UTC

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.

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

#4

Post by chamik » Wed, Jun 21, 2023, 12:07 PM UTC

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

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

#5

Post by fulafel » Wed, Jun 21, 2023, 12:15 PM UTC

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.

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

#6

Post by hu3 » Wed, Jun 21, 2023, 2:23 PM UTC

fulafel wrote: post #5

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.

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

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

#7

Post by vishesh92 » Wed, Jun 21, 2023, 8:37 PM UTC

sigg3 wrote: post #3

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.

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

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

#8

Post by faangsticle » Fri, Jun 23, 2023, 3:27 AM UTC

fulafel wrote: post #5

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.

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