meta_pixel
Tapesearch Logo
Log in
Talk Python To Me

#366: Optimizing PostgreSQL DB Queries with pgMustard

Talk Python To Me

Michael Kennedy

Technology

4.8635 Ratings

🗓️ 20 May 2022

⏱️ 74 minutes

🧾️ Download transcript

Summary

Does your app have a database? Does that database play an important role in how the app operations and users perceive its quality? Most of you probably said yes to the first, and definitely to the second. But what if your DB isn't doing as well as it should? How would you know? And once you know, what do you do about it? On this episode, we're joined by Michael Christofides, co-creator of pgMustard, to discuss and explore the EXPLAIN command for Postgres and other databases as well as all the recommendations you might dig into as a result of understanding exactly what's happening with you queries.

Transcript

Click on a timestamp to play from that location

0:00.0

Does your app have a database? Does that database play an important role in how the app operates

0:05.1

and how users perceive its quality? Most of you probably said yes to that first question,

0:10.6

and definitely to the second. But what if your database isn't doing as well as it should?

0:16.0

How do you know? And once you know, what do you do about it? On this episode, we're joined by

0:20.7

Michael Christophide,

0:22.2

co-creator of PG Mustard,

0:23.8

to discuss and explore the Explain Command for Postgres

0:26.8

and other databases,

0:28.2

as well as all the recommendations you might dig into

0:30.9

as a result of understanding exactly what's happening with your queries.

0:34.6

This is Talk Python to Me, episode 366, recorded May 11th, 2022.

0:53.4

Welcome to Talk Python, a weekly podcast on Python.

0:56.8

This is your host, Michael Kennedy.

0:58.6

Follow me on Twitter where I'm at M. Kennedy and keep up with a show and listen to past episodes at TalkPython.fm.

1:04.7

And follow the show on Twitter via at Talk Python.

1:07.9

We've started streaming most of our episodes live on YouTube. Subscribe to our YouTube

1:12.3

channel over at TalkPython.fm slash YouTube to get notified about upcoming shows and be part of that

1:18.2

episode. Transcripts for this and all of our episodes are brought to you by AssemblyAI. Do you need a

1:24.3

great automatic speech-to-text API? Get human-level accuracy in just a few lines of code.

1:28.3

Visit talk python.fm slash assembly AI.

1:32.3

Hey there, before we jump into the conversation with Michael,

1:35.3

let me just tell you about a new course we just released.

...

Please login to see the full transcript.

Disclaimer: The podcast and artwork embedded on this page are from Michael Kennedy, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Michael Kennedy and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.

Copyright © Tapesearch 2025.