TopPodcast.com
Menu
  • Home
  • Top Charts
  • Top Networks
  • Top Apps
  • Top Independents
  • Top Podfluencers
  • Top Picks
    • Top Business Podcasts
    • Top True Crime Podcasts
    • Top Finance Podcasts
    • Top Comedy Podcasts
    • Top Music Podcasts
    • Top Womens Podcasts
    • Top Kids Podcasts
    • Top Sports Podcasts
    • Top News Podcasts
    • Top Tech Podcasts
    • Top Crypto Podcasts
    • Top Entrepreneurial Podcasts
    • Top Fantasy Sports Podcasts
    • Top Political Podcasts
    • Top Science Podcasts
    • Top Self Help Podcasts
    • Top Sports Betting Podcasts
    • Top Stocks Podcasts
  • Podcast News
  • About Us
  • Podcast Advertising
  • Contact
Not in our directory?
Add Show Here
Podcast Equipment
Center

toppodcastlogoOur TOPPODCAST Picks

  • Comedy
  • Crypto
  • Sports
  • News
  • Politics
  • True Crime
  • Business
  • Finance

Follow Us

toppodcastlogoStay Connected

    View Top 200 Chart
    Back to Rankings Page
    Technology

    Postgres FM

    A weekly podcast about all things PostgreSQL

    Advertise

    Copyright: © 2022 Nikolay Samokhvalov and Michael Christofides

    • Apple Podcasts
    • Google Play
    • Spotify
    Latest Episodes:
    Index maintenance Sep 23, 2022
    Show notes

    Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry!

    Here are links to a few things we mentioned:

    • pgstattuple
    • pg_repack
    • postgres-checkup
    • Workload Analysis for GitLab.com
    • Bloat Analysis (also from GitLab)
    • Bloat, pg_repack, and deferred constraints (blog post by Miro)
    • amcheck
    • Peter Geoghegan interview (on Postgres TV)


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc.

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    Query macro analysis intro Sep 16, 2022
    Show notes

    Here are links to a few things we mentioned:

    • pg_stat_statements
    • pgFouine
    • pgBadger
    • pg_query
    • pg_stat_activity
    • auto_explain
    • Can auto_explain (with timing) have low overhead? (blog post by Michael)
    • track_io_timing
    • pgbench
    • PgHero
    • pgCenter
    • pgwatch2 (Postgres AI edition)
    • pg_stat_kcache
    • PASH Viewer


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc.

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the amazing artwork
    WAL and checkpoint tuning Sep 09, 2022
    Show notes

    Here are links to a few things we mentioned:

    • LSN (log sequence number)
    • On the impact of full-page writes (blog post by Tomas Vondra)
    • Deep dive on Aurora Postgres (talk by Grant McAlister)
    • Netdata monitoring
    • PostgresqlCO.NF
    • pgPedia


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our Google doc.

    If you would like to share this episode, here's a good link (and thank you!)

    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    Intro to query optimization Sep 02, 2022
    Show notes

    Here are links to a few things we mentioned:

    • Using EXPLAIN (PostgreSQL documentation)
    • explain.depesz.com
    • explain.dalibo.com
    • pgMustard
    • EverSQL
    • pganalyze
    • pg_stat_monitor (Extension by Percona)
    • Recent thread on hackers mailing list about plan_id in pg_stat_activity
    • auto_explain
    • EXPLAIN observer effect (Ongres blog post by Álvaro Hernández)
    • auto_explain overhead (blog post by Michael)
    • pg_test_timing
    • Database Lab Engine (for thin clones)
    • Our previous episode on BUFFERS
    • EXPLAIN Explained (talk by Josh Berkus)
    • A beginner's guide to EXPLAIN (talk by Michael)
    • A deeper dive into EXPLAIN (talk by Michael)
    • EXPLAIN glossary (pgMustard docs)
    • Topic suggestions document


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our Google doc.

    If you would like to share this episode, here's a good link (and thank you!)

    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    How to become a DBA Aug 26, 2022
    Show notes

    And few things we mentioned:

    • Topic request on Reddit — thanks HerbyHoover!
    • Haki Benita's blog
    • PostgreSQL documentation (table of contents)
    • Planet PostgreSQL (blog aggregator)
    • MVCC Unmasked (by Bruce Momjian)
    • The Internals of PostgreSQL (by Hironobu SUZUKI)
    • PostgreSQL 14 Internals — parts I and II (by Egor Rogov)
    • Cybertec blog
    • modern-sql.com (by Markus Winand)
    • use-the-index-luke.com (by Markus Winand)
    • The Art of PostgreSQL (by Dimitri Fontaine)
    • explain.depesz.com
    • explain.dalibo.com

    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    Monitoring checklist Aug 19, 2022
    Show notes

    Monitoring checklist (dashboard 1):

    1. TPS and (optional but also desired) QPS
    2. Latency (query duration) — at least average. Better: histogram, percentiles
    3. Connections (sessions) — stacked graph of session counts by state (first of all: active and idle-in-transaction; also interesting: idle, others) and how far the sum is from max_connection (+pool size for PgBouncer).
    4. Longest transactions (max transaction age or top-n transactions by age), excluding autovacuum activity
    5. Commits vs rollbacks — how many transactions are rolled back
    6. Transactions left till transaction ID wraparound
    7. Replication lags / bytes in replication slot / unused replication slots
    8. Count of WALs waiting to be archived (archiving lag)
    9. WAL generation rates
    10. Locks and deadlocks
    11. Basic query analysis graph (top-n by total_time or by mean_time?)
    12. Basic wait event analysis (a.k.a. “active session analysis” or “performance insights”)

    And links to a few things we mentioned:

    • Postgres monitoring review checklist (community document)
    • pgstats.dev
    • Improving Postgres Connection Scalability: Snapshots (blog post by Andres Freund)
    • Transaction ID Wraparound in Postgres (blog post by David Cramer)
    • Subtransactions Considered Harmful (blog post by Nikolay)
    • datadoghq.com
    • pgwatch2 (Postgres.ai Edition)


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    Vacuum Aug 12, 2022
    Show notes

    Here are links to a few things we mentioned:

    • Do you vacuum everyday? (talk by Hannu Krosing)
    • Autovacuum tuning (EDB guide)
    • When autovacuum does not vacuum (2ndQuadrant blog post by Tomas Vondra)
    • Autovacuum tuning basics (old 2ndQuadrant blog post)
    • Discussion with Anastasia Lubennikova (on RuPostgres, in Russian)
    • B-tree indexes (talk by Anastasia Lubennikova, in English)
    • Discussion with Peter Geoghegan (on Postgres TV)
    • pg_repack
    • pg_squeeze


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    NULLs: the good, the bad, the ugly, and the unknown Aug 05, 2022
    Show notes

    Here are links to a few things we mentioned:

    • Three-valued_logic (Wikipedia)
    • Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert)
    • Practical SQL for Data Analysis — Interpolation (blog post by Haki Benita)
    • What is the deal with NULLs? (blog post by Jeff Davis)
    • NULL in SQL: Indicating the Absence of Data (Markus Winand on Modern SQL)
    • The Art of PostgreSQL (book by Dimitri Fontaine)


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    BUFFERS by default Jul 29, 2022
    Show notes

    Here are links to a few things we mentioned:

    • EXPLAIN parameters (PostgreSQL documentation)
    • EXPLAIN (ANALYZE) needs BUFFERS (blog post by Nikolay)
    • Using BUFFERS for query optimization (blog post by Michael)
    • H3 indexes on PostGIS data (blog post by Ryan Lambert)
    • Turning BUFFERS on by default (latest patch)
    • pgMustard
    • explain.depesz.com
    • explain.dalibo.com
    • Database Lab Engine


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    BRIN indexes Jul 21, 2022
    Show notes

    Here are links to the two main resources we mentioned:

    • Paul Ramsey's recent blog post on BRIN indexes
    • Tomas Vondra's slides on BRIN index improvements


    A few other things we mentioned:

    • B-tree Wikipedia page
    • pg_repack
    • pg_squeeze


    ------------------------


    What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

    If you would like to share this episode, here's a good link (and thank you!)


    Postgres FM is brought to you by:

    • Nikolay Samokhvalov, founder of Postgres.ai
    • Michael Christofides, founder of pgMustard


    With special thanks to:

    • Jessie Draws for the elephant artwork
    Previous 1 17 18 19 20 Next

    Related Podcasts

    Reply All

    1

    Reply All Games & Hobbies
    Inside VR & AR

    2

    Inside VR & AR Gadgets
    Note to Self

    3

    Note to Self News
    BrainStuff

    4

    BrainStuff Natural Sciences
    This Week in Tech (Audio)

    5

    This Week in Tech (Audio) News
    Hands-On Tech (Audio)

    6

    Hands-On Tech (Audio) Technology
    footer-logo

    Contact Us

    Toll Free: 844-670-7747

    Links

    • Home
    • Top Charts
    • Networks
    • Apps
    • Independents Podcasts
    • Podcast Advertising
    • Podcast News
    • Contact Us
    • About Us
    • Analytics & Insights

    Stay Connected

      Privacy, Terms of Use & Our Code of Ethics Protecting Content Creators Copyrights