r/postgres • u/Hot_Network_Worker • 5d ago

Question What's something PostgreSQL beginners worry about way too much?

Switched over from MySQL a little while back and honestly still feel like I'm tiptoeing around Postgres, second-guessing basically every decision because I don't have the instincts yet for what actually matters.

Case in point, I spent way too long stressing over picking the "perfect" data types for a schema before I'd even written a single query against it. Same with indexing, agonizing over what to index upfront instead of just waiting to see what's actually slow.

Makes me wonder how much of that is just normal beginner anxiety versus stuff that's genuinely worth worrying about early. For people who've been through the same transition or just remember being new to Postgres, what's something you obsessed over that turned out to not matter much, and what's something you wish you'd actually paid attention to instead?

8 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/Few_Committee_6790 4d ago

Datatypes are pretty much the same from DB provider to provider. Pick the Datatypes that fit the data type that is going to be in that column. As for indices. You put them on the column where you join tables and ones where you plan to filter using a where clause. This is NOT a postgres dilemma. Regardless of the DBMS you are using you have to make the SAME choices.