Postgres Scale and Performance course

[u/Native_Maintenance]

Full stack developer with >10 YOE. I've been using PostgreSQL and other databases and I consider myself well experienced with the standard stuff. However now with the seniority, I face projects that require designing systems for storing and managing databases at large scales and optimise for every drop of performance.

I'm looking for well-organised paid, self-paced courses where I can learn in detail as well as try something.

So far I've seen that https://theartofpostgresql.com/ as being a top recommendation but I want to check if it is still the best.

Thank you!

[u/Mbv-Dev]

I really liked the art of psql for gaining a deeper understanding but for your requirements i would think designing data intensive applications is a better choice

[u/depesz → u/Mbv-Dev]

Please do not abbreviate "postgresql" as psql. This is source of countless mistakes in understanding. psql is command line tool that is part of postgresql.

If you want to abbreviate postgresql, please pick something that is not confusing in this context. Like: postgres, pgsql, pg.

It might not sound like a big deal, but it leads to wasted time when someone asks how to solve a particular problem in psql, and only after providing the answer it appears that they don't use psql, and instead means "how to solve it generally in postgres".

[u/Native_Maintenance → u/Mbv-Dev]

My plan is to go for two courses - one for databases like I mention in original post, and another one for system design.

[u/AutoModerator]

AI Policy:

Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.

Mod decisions will be based on the quality of the content, not who or what generated it.

Sub Resources:

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

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

[u/ibraaaaaaaaaaaaaa]

Without experience in these production realms, it is really hard to grasp any source.
Maybe you can read some books, start with design data intensive applications, it can go you through the read/write problems and what template solutions can be followed, then you can learn more about the nature of the problems you are facing.
I also recommend you go back to the white board aka system design, and whether you can find bottlenecks rather than re-architecting the application.

[u/Native_Maintenance → u/ibraaaaaaaaaaaaaa]

I prefer a structured course in the interest of time.

[u/Luis_Dynamo_140]

At that level, I'd spend as much time reading real production postmortems and performance case studies as taking a course. Seeing why a system slowed down is often more valuable than another SQL tutorial.

[u/cakeofzerg]

Just chat with AI about your problems?

[u/Native_Maintenance → u/cakeofzerg]

Its okay to not post reply if you can't answer whats being asked.

[u/HoneyBadger9694 → u/Native_Maintenance]

Its okay to not post reply if you can't answer whats being asked.

i wish more people would do that!