Shows
Postgres FMWhat's new in EXPLAINNik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. Here are some links to things they mentioned: EXPLAIN (official docs) https://www.postgresql.org/docs/current/sql-explain.htmlUsing EXPLAIN (official docs) https://www.postgresql.org/docs/current/using-explain.html EXPLAIN glossary (pgMustard site) https://www.pgmustard.com/docs/explainPostgres 18 release notes https://www.postgresql.org/docs/release/18.0/Enable BUFFERS with EXPLAIN ANALYZE by default (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebOur (first) BUFFERS by default episode https://postgres.fm/episodes/buffers-by-default Show index search coun...
2025-11-2145 minPostgres FMGIN IndexesNikolay and Michael discuss GIN indexes in Postgres — what they are, what they're used for, and some limitations to be aware of. Here are some links to things they mentioned:GIN Indexes https://www.postgresql.org/docs/current/gin.htmlGeneralized Search Trees for Database Systems (Hellerstein, Naughton, Pfeffer) https://dsf.berkeley.edu/papers/vldb95-gist.pdf RUM extension https://pgxn.org/dist/rum/1.1.0/Understanding Postgres GIN Indexes: The Good and the Bad (Lukas Fittl) https://pganalyze.com/blog/gin-index~~~What did you like or not like? What should we discuss next time? Let...
2025-03-1440 minPostgres FMShould we use foreign keys?Nikolay and Michael discuss foreign keys in Postgres — what they are, their benefits, their overhead, some edge cases to be aware of, some improvements coming, and whether or not they generally recommend using them. Here are some links to things they mentioned:Foreign keys (docs) https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-FKOur episode about constraints: https://postgres.fm/episodes/constraintsGitLab migration helper add_concurrent_foreign_key https://github.com/gitlabhq/gitlabhq/blob/master/rubocop/cop/migration/add_concurrent_foreign_key.rbAdding a foreign key without downtime (tweet by Nikolay) https://x.com/samokhvalov/status/1732056107483636188Blo...
2024-06-2151 minPostgres FMMinor releasesNikolay and Michael discuss Postgres minor releases — how the schedule works, options for upgrading to them, and the importance of reading the release notes. Here are some links to things they mentioned:PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 released (announcement) https://www.postgresql.org/about/news/postgresql-163-157-1412-1315-and-1219-released-2858/ PostgreSQL versioning policy https://www.postgresql.org/support/versioning/ PostgreSQL 14.4 release notes (most recent minor release not on the usual schedule) https://www.postgresql.org/docs/release/14.4/ Minor release roadmap https://www.postgresql.org/developer/roadmap/ Our last episode on upgrades (major and minor) https://postgres.fm/episodes/upgrade...
2024-05-1739 minPostgres FMCustom vs generic planNikolay and Michael discuss custom and generic planning in prepared statements — how it works, how issues can present themselves, some ways to view the generic plan, and some benefits of avoiding planning (not just time). Here are some links to things they mentioned:PREPARE https://www.postgresql.org/docs/current/sql-prepare.html track_activity_query_size https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE plan_cache_mode https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-PLAN-CACHE-MODE EXPLAIN (GENERIC_PLAN) https://www.postgresql.org/docs/current/sql-explain.html#id-1.9.3.148.8 EXPLAIN (GENERIC_PLAN) in PostgreSQL 16 (blog post by Laure...
2024-05-1029 min
Adventures in DevOpsThe Future of Database Administration - DevOps 195Lukas Fittl is the Founder of Pganalyze. They delve into the latest developments and challenges in the world of DevOps and technology. They discuss the evolving role of database administrators (DBAs), focusing on the challenges of optimizing database performance, specifically addressing slow queries in Postgres databases. The conversation highlights the need for visibility and understanding of database performance, as well as the development of Pganalyze, a startup aimed at improving Postgres performance. Tune in to gain insights into the changing landscape of DBAs and the complexities of database optimization in today's technology-driven world.SocialsLinkedIn: Lukas Fittl
2024-04-0448 minPostgres FMSearchNikolay and Michael have a high-level discussion on all things search — touching on full-text search, semantic search, and faceted search. They discuss what comes in Postgres core, what is possible via extensions, and some thoughts on performance vs implementation complexity vs user experience. Here are some links to things they mentioned:Simon Riggs https://www.linkedin.com/feed/update/urn:li:activity:7178702287740022784/Companion databases episode https://postgres.fm/episodes/companion-databasespgvector episode https://postgres.fm/episodes/pgvectorFull Text Search https://www.postgresql.org/docs/current/textsearch.htmlSemantic search https://en.wikipedia.org/wiki/Semantic_searchFaceted search htt...
2024-03-2941 min
DevOps and Docker Talk: Cloud Native Interviews and ToolingPostgres in ContainersBret and Nirmal are joined by Lukas Fittl of pganalyze to dive into Postgres in containers, in production, and in CI.🙌 My next course is coming soon! I've opened the waitlist for those wanting to go deep in GitHub Actions for DevOps and AI automation in 2025. I'm so thrilled to announce this course. The waitlist allows you to quickly sign up for some content updates, discounts, and more as I finish building the course. https://learn.bretfisher.com/waitlist🍾Lukas is an expert and founder of pganalyze, and I invited him on the show t...
2024-03-0846 minPostgres FMRails + PostgresMichael and Nikolay are joined by Andrew Atkinson, author of High Performance PostgreSQL for Rails, to discuss how Rails and Postgres work together — where the limits are, how people use the ORM, things that are improving, and some things we can do as a Postgres community to make it even better. Here are some links to things they mentioned:Planet Argon survey https://rails-hosting.com/2022/#databasesActive Record https://guides.rubyonrails.org/active_record_basics.htmlPostgreSQL specific usage of Active Record https://guides.rubyonrails.org/active_record_postgresql.htmlMultiple Databases with Active Record https://guides.rubyonrails.org/act...
2024-03-0145 min
Talking Postgres with Claire GiordanoMy Journey into Postgres Monitoring with Lukas Fittl & Rob TreatDo you monitor your Postgres error logs for gold? Lukas Fittl and Rob Treat join Claire Giordano and Pino de Candia on the Path To Citus Con* podcast for developers who love Postgres—to discuss their respective journeys into Postgres monitoring. Have you ever asked yourself: “Why is my query so slow?” Or had to figure out which query is slowing things down? Or why your database server is at 90% CPU? There are so many ways to monitor Postgres: pganalyze, pgMustard, pgBadger, pgDash, your cloud provider’s Query Performance Insights, pg_stat_statements, pg_stat_io, & more. If you’re running...
2023-12-081h 21
The SaaS Podcast: Build, Launch & Scale Your SaaS374: pganalyze: The Unconventional Path to a 7-Figure SaaS - with Lukas FittlLukas Fittl is the founder of pganalyze, a tool that offers automatic insights for developers to optimize their databases and improve performance.Show Notes: https://saasclub.io/374Join Email List: Get weekly SaaS learnings, new podcast episodes, and actionable insights right in your inbox: https://saasclub.io/email/Join Community: SaaS Club is the community for early-stage SaaS founders and entrepreneurs: https://saasclub.co/join
2023-11-0956 min
Data Engineering PodcastShining Some Light In The Black Box Of PostgreSQL PerformanceSummary
Databases are the core of most applications, but they are often treated as inscrutable black boxes. When an application is slow, there is a good probability that the database needs some attention. In this episode Lukas Fittl shares some hard-won wisdom about the causes and solution of many performance bottlenecks and the work that he is doing to shine some light on PostgreSQL to make it easier to understand how to keep it running smoothly.
Announcements
Hello and welcome to the Data Engineering Podcast, the show about modern data management
Introducing RudderStack Profiles...
2023-11-0654 min
Programming Throwdown166: Speedy Database Queries with Lukas Fittl- 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...
2023-10-161h 12
Heavybit Podcast Network Master Feedo11ycast - Ep. #63, Observability in the Database with Lukas Fittl of pganalyzeIn episode 63 of o11ycast, Charity and Jess speak with Lukas Fittl of pganalyze about database observability. This talk explores relational database management systems (DBMS), the open source library Sqlcommenter, query plans, and insights on supporting application teams.
2023-10-0436 min
Heavybit PodcastsEp. #63, Observability in the Database with Lukas Fittl of pganalyzeIn episode 63 of o11ycast, Charity and Jess speak with Lukas Fittl of pganalyze about database observability. This talk explores relational database management systems (DBMS), the open source library Sqlcommenter, query plans, and insights on supporting application teams.The post appeared first on Heavybit.
2023-10-0436 min
O11ycastEp. #63, Observability in the Database with Lukas Fittl of pganalyzeIn episode 63 of o11ycast, Charity and Jess speak with Lukas Fittl of pganalyze about database observability. This talk explores relational database management systems (DBMS), the open source library Sqlcommenter, query plans, and insights on supporting application teams.The post appeared first on Heavybit.
2023-10-0436 min
Software Engineering Radio - The Podcast for Professional Software DevelopersLukas Fittl on Postgres PerformanceLukas Fittl of pganalyze discusses the performance of Postgres, one of the world's most popular database systems. SE Radio host Philip Winston speaks with Fittl about database indexing, queries, maintenance, scaling, and stored procedures. They also discuss some features of pganalyze, such as the index and vacuum advisors.
2023-09-281h 11Software Engineering Radio - the podcast for professional software developersLukas Fittl on Postgres PerformanceLukas Fittl of pganalyze discusses the performance of Postgres, one of the world's most popular database systems. SE Radio host Philip Winston speaks with Fittl about database indexing, queries, maintenance, scaling, and stored procedures. They also discuss some features of pganalyze, such as the index and vacuum advisors.
2023-09-281h 11Software Engineering Radio - the podcast for professional software developersLukas Fittl on Postgres PerformanceLukas Fittl of pganalyze discusses the performance of Postgres, one of the world's most popular database systems. SE Radio host Philip Winston speaks with Fittl about database indexing, queries, maintenance, scaling, and stored procedures. They also discuss some features of pganalyze, such as the index and vacuum advisors.
2023-09-281h 11Postgres FMOur favourite v16 featureNikolay and Michael discuss their favourite feature each from the upcoming PostgreSQL 16 release. Here are some links to some things they mentioned:v16 draft release notes https://www.postgresql.org/docs/16/release-16.htmlPGSQL Phriday #012 invitation from Ryan Booz https://www.pgsqlphriday.com/2023/08/pgsql-phriday-012/ Subscribe options for the podcast https://postgres.fm/subscribeA recent closed source ClickHouse feature https://github.com/ClickHouse/ClickHouse/issues/44767#issuecomment-1683293218 Postgres TV hacking session with Andrey Borodin on \watch with limited number of loops (v16) https://www.youtube.com/watch?v=vTV8XhWf3mo Allow \watch queries to stop on minimum rows retu...
2023-09-0827 min
TechONTAPPodcastEpisode 374 - Improving Postgres with pganalyzePostgres is a popular open source database that powers applications for companies such as Atlassian and DoorDash due to its cost, performance and versatility. But what if you could make Postgres perform better?
Pganalyze gives you visibility into your Postgres database deployments and its queries to make suggestions for improvements, tuning and maintenance. Pganlyze CEO and founder Lukas Fittl joins us to discuss all the ins and outs of Postgres, as well as how pganalyze makes life better for the Postgres database admin.
2023-09-0639 min
TestGuild Devops Toolchain PodcastPostgres Performance at Any Scale with Lukas FittlWelcome to another episode of the DevOps Toolchain podcast! In this episode, we have a special guest, Lukas Fittl, an experienced engineer and entrepreneur known for his work in optimizing Postgres performance. Lukas will share his insights and tips on tuning Postgres databases for optimal performance. We'll explore the different tuning aspects, including using managed services like Amazon RDS or Amazon Aurora, general best practices, and understanding where bottlenecks occur. Lukas will also discuss his journey in developing a comprehensive tool called pganalyze, which provides valuable insights and recommendations for optimizing Postgres performance. But that's not all! We'll also...
2023-07-2728 min
Talking Postgres with Claire GiordanoMy favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan BoozEveryone learns differently. Grant Fritchey and Ryan Booz, database advocates at Redgate focusing on PostgreSQL, talk with Path To Citus Con* co-hosts Claire Giordano and Pino de Candia to explore the learning resources available to developers and users in all the corners of the PostgreSQL world. What drives you to learn: need or curiosity? What can podcasts teach us while we bike to work? Are conference talks good for growing skills, or are they better for networking? What about books? And do older books still have much to offer? It turns out, most people need much more than one...
2023-07-141h 18Postgres FMRead-only considerationsNikolay and Michael discuss a listener request — special considerations for databases that are used in a read-only mode all day, and get an update at night with additional data.Here are links to a few things we mentioned: Index-only scansVacuumUK Covid-19 dashboardpg_repackPartitioningOur episode on BRIN indexesAlways load sorted data (blog post by Haki Benita)GIN indexes: the good and the bad (blog post by Lukas Fittl)Our episode on materialised viewspg_buffercacheTowards Millions TPS (blog post by Alexander Korotkov)Postgres WASM (by Snaplet and Supabase)YugabyteAWS Aurora Continuous Archiving and Point-in-Time Recovery (docs)Our episode on c...
2023-04-1439 minPostgres FMMaterialized viewsApologies, Michael's audio is not great in this, we'll hopefully be back to normal next week!Here are links to a few things we mentioned: Materialized views (docs)Refresh materialized view (docs)Timescale blog postPlanetScale Boost (content warning: MySQL) Incremental Materialized Views with pg_ivm (video by Lukas Fittl) Articles on how to do your own incremental updates(?)Materialize (company) Materialize talkIncremental View Maintenance (Postgres wiki) Implementing Incremental View Maintenance (mailing list thread) ------------------------What did you like or not like? What should we discuss next time? Let us know b...
2022-11-2541 minPostgres FMHOT updatesHere are links to a few things we mentioned: Heap-only tuple updates (docs)README file (source code)Heap Only Tuple chapter (Internals of PostgreSQL by Hironobu SUZUKI) How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay) Why Uber switched from Postgres to MySQL (blog post) Fighting write amplification with HOT updates (Adyen blog post) HOT Updates vs Bottom-Up Index Deletion (video by Lukas Fittl from pganalyze) Reduced Bloat with Bottom-Up Deletion (blog post by Hamid Akthar from Percona) What is fillfactor and how does it affect performance? (blog post by Kaarel Moppel from Cyberte...
2022-11-1830 min
Code with Jason160 - PostgreSQL with Andrew AtkinsonIn this episode I talk with Andrew Atkinson about PostgreSQL and databases. We talk about check constraints, foreign keys, and other PostgreSQL/database concepts.Andy Atkinson.comAndrew Atkinson on TwitterAndrew Atkinson on GitHubPuny to Powerful PostgreSQL Rails Apps (RailsConf 2022 talk)Creating a constraint that is initially "not valid"Slides 16 & 17 of this presentation also deal with "not valid" constraintsThe Strong Migrations gem at GithubLukas Fittl's pganalyzeHaki Benita's post on adding constraints without validating immediately
2022-08-2957 min
Future Weekly#31 - Der Aufstieg der Abos, Uber kauft Postmates, Farewell Soup.ioMarkus Raunig und Daniel Cronin diskutieren diese Woche folgende Themen:1. News der Woche: Uber kauft Postmates, Sony bringt tragbare Klimaanlage auf den Markt, Soup.io wird eingestellt, Trump erlaubt doch internationale Studierende, Next level company retreats, 2. Deep Dive: Der Aufstieg der Abos: Von Walmart bis Twitter3. Rockstars der Woche: Christopher Clay, Lukas Fittl, Andreas Fuchs, Esad Hajdarevic und Florian Hufsky4. Moonshots & Predictions: Subscriptions werden zum Standard---Weiterlesen:Sony Launches Wearable Air Conditioner (interestingengineering): https://t1p.de/uxioSoup.io: Ein Kapitel österreichischer Startup-Geschichte (TT):
2020-07-161h 21