Beginner tips
Postgres FM
Pjab Mean: A Better UI for Beginners
Postgres is still a long way behind MySQL. I think they're better free and even open source graphical user interfaces available. There are some better tools if you want UI but main advice for me is learn console Pj. You can code something in it you can make your colleagues repeat the very same steps you did right because it will be a script Well more than that.
00:00
Transcript
Play full episode
Transcript
Episode notes
Speaker 2
You're listening to Ricky and Jimmy on Relationships, the show where we uncover the thoughts and behaviors that are sabotaging your relationship and what you can do about it. Jimmy and I are passionate about sharing the ways that imperfect partners like you and I can shift unhealthy relational dynamics and create closeness. So welcome, drop your defenses and open your heart, eyes and ears. Let's learn how to be the best partner we can be together. Okay, welcome back everybody. Today we have such a special guest. Jimmy and I are thrilled to introduce Julie Manano. She's a licensed marriage and family therapist who specializes in emotionally focused therapy, which my audience might recognize is kind of the gold standard for dealing with attachment issues. But even more exciting, Julie's got a new book coming out. So today we're going to be talking a lot about her new book, Secure Love, create a relationship that lasts a lifetime. And for the folks who can't see Jimmy's holding it up, he has an advanced copy. Very exciting. Julie, thank you so much for talking to us today. Jimmy and I have been talking about your account long as we have had a podcast. Wow. Well, I
Speaker 1
know you guys are both have been long time supporters and I just really appreciate that. And I love how we're all working together here to get these messages out. And I appreciate you guys too.
Speaker 3
was let me tell you one quick story about about so obviously like you've already established, you're you're one of the first accounts that Ricky and I talked about once we once we got introduced to each other. If we haven't mentioned it, your handle is at the secure relationship. We already mentioned that right? Anyways, if you're
Speaker 1
not checked, because there are a lot of imposters. Oh my gosh. Yes.
Nikolay and Michael discuss 10 beginner tips Nikolay recently shared — they go into a bit more detail on each, and even disagree a little on one or two!
Here are some links to some things they mentioned:
- Nikolay’s tweet with all 10 tips: https://twitter.com/samokhvalov/status/1679953049899642880
- Tip 1: tuples are physical versions of rows
- Related episodes: https://postgres.fm/episodes/how-to-become-a-dba and https://postgres.fm/episodes/hot-updates
- Tip 2: always use EXPLAIN (ANALYZE, BUFFERS)
- Related episode: https://postgres.fm/episodes/buffers-by-default
- Tip 3: throw away pgAdmin
- Related episode: https://postgres.fm/episodes/psql-vs-guis
- Tip 4: enable as much logging as you can afford
- Related episode: https://postgres.fm/episodes/default-configuration
- Tip 5: install pg_stat_statements
- Related episodes: https://postgres.fm/episodes/pg_stat_statements and https://postgres.fm/episodes/auto_explain, and https://postgres.fm/episodes/macro-query-analysis-intro
- Tip 6: run experiments on realistic data sets (use thin cloning and branching)
- Related episode: https://postgres.fm/episodes/database-branching
- Tip 7: make sure data checksums are enabled
- Related episode: https://postgres.fm/episodes/corruption
- Tip 8: tune autovacuum to run frequently and move faster
- Related episode: https://postgres.fm/episodes/vacuum
- Tip 9: query optimization will eventually be more important than configuration tuning
- Related episodes: https://postgres.fm/episodes/intro-to-query-optimization and https://postgres.fm/episodes/102-query-optimization
- Tip 10: indexes need to be rebuilt, unfortunately, since their health decline over time
- Related episode: https://postgres.fm/episodes/index-maintenance
- Bonus tip: the official documentation, release notes, and source code comments/readmes are your friends!
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
