Skip to content
166: Speedy Database Queries with Lukas Fittl episode artwork

Oct 16, 2023 1 hr 12 min

166: Speedy Database Queries with Lukas Fittl

from Programming Throwdown Hosted by Patrick Wheeler and Jason Gauci

pganalyze: - Weekly series "5mins of Postgres": - How Postgres chooses which index to use: - CMU databases courses: - Postgres community: As well as social links: - Mastodon: - Twitter/X: @pganalyze, @LukasFittl - GitHub: @pganalyze, @lfittl - LinkedIn.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

166: Speedy Database Queries with Lukas Fittl

0:00 1:12:12

Chapters

  1. 0:00 Introduction and Guest Background
  2. 4:02 Career Path and Growth
  3. 6:04 The Difference Between Being a Developer and a Leader
  4. 13:31 The Pitfalls of Specialized Databases
  5. 16:03 The Mechanics of Indexing
  6. 21:10 How Index Lookups Work
  7. 27:06 The risks of over-prescribing SQL
  8. 28:37 The role of EXPLAIN
  9. 30:54 How the planner works
  10. 33:50 Cost-based estimation
  11. 35:48 Environment differences
  12. 39:50 MVCC and Concurrency
  13. 42:00 Visibility Rules
  14. 45:21 Using EXPLAIN ANALYZE and Buffers
  15. 48:02 Indexing vs. Data Modeling
  16. 50:12 Optimizing for Data Locality
  17. 56:44 The Evolution of Database Administration
  18. 58:31 pganalyze Architecture
  19. 1:01:47 Empowering Application Teams
  20. 1:04:28 Building a Startup from a Side Project
  21. 1:08:54 Resources for Database Enthusiasts

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

The Self-Worth Project Jenn Stevens Welcome to The Self-Worth Project! Hosted by Jenn Stevens, coach, hypnotist, and creator of The Aligned Life This podcast is designed to help you remember who you really are: underneath the layers of pain, shame, and programming that are keeping you small. Let's ditch the unhealthy patterns so we can create the life we really want, without apology. Disability Law Show CKNW Programming Samfiru Tumarkin LLP is a Toronto-based law firm that specializes in labour and employment law, as well as personal injury and insurance claims. KMOJCast KMOJ-89.9 FM “The People’s Station” Select programming from KMOJ's airwaves and community voices. Since first going “on the air” in 1976, KMOJ-89.9-FM continues its legacy as the community-oriented station located in Minneapolis, Minnesota airing a predominantly urban adult contemporary format.“KMOJ’s Community Viewpoint” is one way the station achieves its mission of engaging, supporting and empowering Communities of Color to elevate the way of life of the people of its community and to challenge social and economic disparities, and the persistent consequences of historic racism. The station call letters, “KMOJ” were inspired by the Swahili word “UMOJA” which means “Unity.” http://kmojfm.com/

Frequently asked questions

How long is this episode of Programming Throwdown?

This episode is 1 hour and 12 minutes long.

When was this Programming Throwdown episode published?

This episode was published on October 16, 2023.

Can I download this Programming Throwdown episode?

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