Programming Throwdown
Programming Throwdown
Patrick Wheeler and Jason Gauci
166: Speedy Database Queries with Lukas Fittl
1 hour 12 minutes Posted Oct 16, 2023 at 3:00 pm.
Speedy Database Queries
How Did I Get into Tech?
Deciding the right database for your job
What's So Different About Postgres?
Rust and Postgres: The Extensibilities
Why queries get slow in a database
database performance, separation of concerns
Do Primary Keys matter in SQL?
C# Query Analysis, Explained
Quantum Planner
Postgres: Statistics and Auto-Analyze
Postgres vs. MySQL: Transaction Costs
Postgres 8.2: Query Plan Optimization
Postgres 10: Normalizing or Denormalizing your Data?
Postgres Performance Metrics
Starting a Business: Lucas
A few tips for learning Postgres
Democracy in Data, Introduction
Punishment for Programming Throwdown
0:00
1:12:12
Download MP3
Show notes

- pganalyze: https://pganalyze.com/

- Weekly series "5mins of Postgres": https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw

- How Postgres chooses which index to use: https://pganalyze.com/blog/how-postgres-chooses-index

- CMU databases courses: https://db.cs.cmu.edu/courses/

- Postgres community: https://www.postgresql.org/community/


As well as social links:

- Mastodon: https://hachyderm.io/@lukas

- Twitter/X: @pganalyze, @LukasFittl

- GitHub: @pganalyze, @lfittl

- LinkedIn: https://www.linkedin.com/in/lfittl/ , https://www.linkedin.com/company/pganalyze/

★ Support this podcast on Patreon ★