Skip to content
102: Postgres Performance Tuning and Query Planner with Bruce Momjian episode artwork

Jun 11, 2016 54 min

102: Postgres Performance Tuning and Query Planner with Bruce Momjian

from Three Devs and a Maybe Hosted by Michael Budd, Fraser Hart, Lewis Cains, Edd Mann

In this weeks episode we are very lucky to be joined by Bruce Momjian to discuss Postgres Performance Tuning and Query Planner. We start off discussion around how Bruce got interested in Database Systems, a brief history of Postgres and his involvement with the project over the years. Following this we highlight the three main areas which affect database performance - hardware, server configuration and SQL/indexing. With this knowledge in hand, we then delve into the Query Planner, demystifying some of the terminology and concepts used (i.e. cost, scan methods and join methods). Finally, we summarise how these concepts are used by Postgres to decide which query plan to pick for a supplied query.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

102: Postgres Performance Tuning and Query Planner with Bruce Momjian

0:00 54:48

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

French Your Way Jessica: Native French teacher founder of French Your Way Boost your French listening skills and test your comprehension with this one of a kind series of podcasts. Get the chance to listen to a real conversation between native speakers talking at normal speed AND customise your learning experience through carefully designed sets of questions (2 levels of difficulty) available for download at www.frenchvoicespodcast.com. All interviews also come with the transcript. French teacher Jessica interviews native speakers of French from around the world who share a bit of their life and passion. Where else would you meet in one same place a French yoga teacher based in Melbourne, a soap manufacturer from Provence, or a couple cycling around the world?

Frequently asked questions

How long is this episode of Three Devs and a Maybe?

This episode is 54 minutes long.

When was this Three Devs and a Maybe episode published?

This episode was published on June 11, 2016.

Can I download this Three Devs and a Maybe episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.