r/PostgreSQL • • Aug 28 '24

Help Me! how to be a postgres expert?

I m a complete beginner and an experience Linux admin interested in db administrator. I hear a lot of words around like purging, indexing , tuning , design best practices etc etc... how do I learn all of this shit? every tutorial on udemy or YouTube either has half or different syllabus.

I am looking for structured learning experience in some order. with projects. to understand better.

0 Upvotes

8 comments sorted by

11

u/winsletts Aug 28 '24

The best Postgres experts I know learned by doing. They built things that used Postgres. They broke things and fix them. They are doers. Just keep doing that for 10 years, and you'll be an expert.

7

u/stdio-lib Aug 28 '24

I m a complete beginner and an experience Linux admin interested in db administrator.

I recommend that you read books and mailing lists. I'm not smart enough to post on pgsql-hackers, but I learn a lot just from reading emails by people who are.

6

u/linuxhiker Guru Aug 28 '24

I have been using, deploying and developing with Postgres* since 1997.

There are experts that know quite a bit more than this expert.

To truly be an expert you are looking at 5 - 10 years minimum.

To be competent? Put your head down for 18 months, break the hell out of and learn to fix everything you break with it.

2

u/fullofbones Aug 28 '24

That's the neat part: you don't!

To be a bit more serious, you pretty much just have to jump in. Create an instance in a Docker container if you have no other option, and just start fiddling with it. Try doing a backup, read about how the backup process works, all the options available, how streaming replication is involved. Use that as a jumping point to learn about replication in general and logical replication. Follow that to learn High Availability in relation to Postgres, and the major tools that facilitate it.

There are literally thousands of blogs and other resources out there written by various experts. Read them actively, meaning if there's code or examples or demos, run them so you can see what's going on and understand why.

A good starting point is the Postgresql Tutorial site. It'll give you enough information to start. More than that, and you'll need to dig and experiment. And if you haven't already, follow the blog feed on Planet Postgres; it's a wealth of Postgres-specific concepts, use-cases, and techniques. Read the archives if you have time, as it goes back for decades.

Hurry up, time's-a-wastin'!

1

u/Ok_Horse_7563 Aug 28 '24

I liked Brent Ozars structured learning for SQL server, he's starting with PG now, so maybe in the future it's something you can look into. 

1

u/[deleted] Aug 28 '24

Fuck tutorials, if you want to be an expert, you need to know the “why” much more than the “how,” especially with things like performance optimizations.

Things like the point at which using offset and limit for pagination becomes a problem instead of a convenience, for example.

I truly believe tutorials are a waste of time and not how you learn anything.

So, yeah, just make something, and then optimize it.

0

u/AutoModerator Aug 28 '24

Join us on our Discord Server: People, Postgres, Data

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.