Rephonic
Artwork for Postgres FM
Postgresql
Logical Replication
Query Optimization
Soft Deletes
Protocol Versions
Compression Algorithms
SQL Practices
Long-Running Transactions
Data Compression
User Experience
DML Operations
Active-Active Replication
Peerdb
Timescaledb
Foreign Keys
Data Compliance
PGLZ
LZ4
Index-Only Scans
Postgres Health Checks

A weekly podcast about all things PostgreSQL

PublishesWeeklyEpisodes168Founded3 years ago
Number of ListenersCategories
NewsTech NewsTechnology

Listen to this Podcast

Artwork for Postgres FM

Latest Episodes

Nik and Michael discuss a listener question about archiving a database.

 

Here are some links to things they mentioned: 

• Listener request to talk about archiving www.youtube.com/watch?v=KFRK8PiIvTg&lc=UgyiFrO37gEgUaVhRgN4AaABAg 

• Our epis... more

Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!)

 

Here are some links to things they mentioned: 

• max_connections www.postgresql.org/docs/curren... more

Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18.

 

Here are some links to things they mentioned: 

• EXPLAIN (official docs) www.postgresql.org/docs/current/sql-explain.html

• Using EXPLAIN (official docs) h... more

Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica.

 

Here are some links to things they mentioned:

• Ultra-fast replica creation with pgBackRest (blog post by Maxim Boguk an... more

Key Facts

Accepts Guests
Contact Information
Podcast Host
Number of Listeners
Find out how many people listen to this podcast per episode and each month.

Similar Podcasts

People also subscribe to these shows.

Recent Guests

Harry Brundage
Co-founder and CTO of Gadget
Gadget
Episode: Gadget's use of Postgres
Simon Eskildsen
CEO and co-founder of TurboPuffer
TurboPuffer
Episode: turbopuffer
Gwen Shapira
Co-founder and chief product officer at Nile
Nile
Episode: Multi-tenant options
Lev Kokotov
Creator of PgDog, a PostgreSQL sharding solution
Episode: PgDog
Franck Pachot
Developer advocate at MongoDB, formerly at YugaDB, and an AWS Data Hero.
MongoDB
Episode: SQL vs NoSQL
Lukas Eder
Founder of Dave Geekery and creator of Duke
Dave Geekery
Episode: jOOQ
Gülçin Yıldırım Jelínek
Staff engineer at Zeta, co-founder of the Prague PostgreSQL Meetup
Zeta
Episode: Is pg_dump a backup tool?
Robert Haas
VP Chief Architect Database Service at EDB, long-serving PostgreSQL contributor
EDB
Episode: Is pg_dump a backup tool?
Alexander Kukushkin
Postgres contributor and maintainer of Patroni, working at Microsoft
Microsoft
Episode: Patroni

Hosts

Nik
Co-host of a technology podcast focused on PostgreSQL.
Michael
Co-host of a technology podcast focused on PostgreSQL.

Reviews

4.9 out of 5 stars from 100 ratings
  • Thanks

    Thanks for this great podcast, I listen to it when I drive or walk, using my time to the fullest.

    Apple Podcasts
    5
    Troublesmade
    United States7 months ago
  • Nikolay & Micheal I listen to your podcasts these are great and lot of insights

    Nikolay & Micheal I listen to your podcasts these are great and lot of insights

    Thank you so much for doing this

    It’s good keep up this Awesome work

    Apple Podcasts
    5
    ChinnaP2
    United States2 years ago
  • Such a fantastic resource!

    It’s current but not “news” so it makes sense to go all the way back to the first episode and listen to all of these!

    As an “application developer” who uses PostGIS, I wish I had known all I have learned through this podcast when we started our project. I now have a long list of things to add, things to check, things to look at - so much!

    Thanks Nikolay and Michael!

    Apple Podcasts
    5
    Endoid
    United Kingdom2 years ago
  • Awesome!

    I cannot recommend this podcast enough. The hosts possess an exceptional depth of knowledge about Postgres, which they generously share with the community. Their engaging personalities make each episode not just informative but also incredibly enjoyable. Listening to them feels like having an engaging conversation with friends over coffee or a casual beer. The way they impart their expertise and make complex topics accessible is truly commendable. A must-listen for anyone interested in Postgres!... more

    Apple Podcasts
    5
    BrunoNero90
    Poland2 years ago
  • Outstanding

    One of the best tech podcasts

    Apple Podcasts
    5
    michael_mancuso
    United States3 years ago

Listeners Say

Key themes from listener reviews, highlighting what works and what could be improved about the show.

Audience feedback emphasizes the show's value for both newcomers to PostgreSQL and seasoned users looking for updates and insights.
Many find the content highly relevant and beneficial for practical application in their database work, contributing to a positive listening experience.
The engaging personalities of the hosts create a pleasant atmosphere that feels conversational and friendly, making learning enjoyable.
Listeners appreciate the expert knowledge and personal insights shared by the hosts, highlighting the approachable manner in which complex technical topics are presented.

Chart Rankings

How this podcast ranks in the Apple Podcasts, Spotify and YouTube charts.

Apple Podcasts
#172
India/Technology
Apple Podcasts
#195
Russia/Technology

Talking Points

Recent interactions between the hosts and their guests.

max_connections vs migrations
Q: What can be a solution to handle issues with migrations and max connections?
Implement a lower lock timeout and retries to prevent long wait periods during migrations due to blocking locks from other transactions.
max_connections vs migrations
Q: What's the ideal max connections?
It's better if we reach max connection sooner and just say some clients retry later, like too many clients, rather than allowing an overwhelming number of active sessions which can hurt performance.
Gadget's use of Postgres
Q: What challenges did you face during your zero downtime upgrade?
We put a lot of work into planning and testing, including a reliable rollback plan, but it was nerve-wracking since we hadn't executed the final switch in a real environment before.
Multigres
Q: What is Multigres and why are you working on it?
Multigres is a Vitess adaptation for Postgres that has been in development for many years, finally coming together as the timing feels right now.
Multi-tenant options
Q: Have you considered the approach used in VTS, where data is brought asynchronously from one shard to another?
Yes, it's a good idea, and we may examine it in the future, focusing on building something useful gradually.

Audience Metrics

Listeners, social reach, demographics and more for this podcast.

Listeners per Episode
Gender Skew
Location
Interests
Professions
Age Range
Household Income
Social Media Reach

Frequently Asked Questions About Postgres FM

What is Postgres FM about and what kind of topics does it cover?

The episodes focus on PostgreSQL, an advanced open-source relational database system, covering a wide range of topics from performance optimization techniques and user management to the latest advancements in database functionalities. Noteworthy discussions include practical solutions to common issues, such as managing database connections and optimizing query performance, along with insights from industry experts and real-world experiences shared by the hosts. This resource is particularly valuable for developers, database administrators, and technology professionals looking to deepen their understanding of PostgreSQL and its applications in modern data management.

Where can I find podcast stats for Postgres FM?

Rephonic provides a wide range of podcast stats for Postgres FM. We scanned the web and collated all of the information that we could find in our comprehensive podcast database. See how many people listen to Postgres FM and access YouTube viewership numbers, download stats, audience demographics, chart rankings, ratings, reviews and more.

How many listeners does Postgres FM get?

Rephonic provides a full set of podcast information for three million podcasts, including the number of listeners. View further listenership figures for Postgres FM, including podcast download numbers and subscriber numbers, so you can make better decisions about which podcasts to sponsor or be a guest on. You will need to upgrade your account to access this premium data.

What are the audience demographics for Postgres FM?

Rephonic provides comprehensive predictive audience data for Postgres FM, including gender skew, age, country, political leaning, income, professions, education level, and interests. You can access these listener demographics by upgrading your account.

How many subscribers and views does Postgres FM have?

To see how many followers or subscribers Postgres FM has on Spotify and other platforms such as Castbox and Podcast Addict, simply upgrade your account. You'll also find viewership figures for their YouTube channel if they have one.

Which podcasts are similar to Postgres FM?

These podcasts share a similar audience with Postgres FM:

1. Scaling Postgres
2. The Changelog: Software Development, Open Source
3. Software Engineering Daily
4. Talk Python To Me
5. The AI Daily Brief: Artificial Intelligence News and Analysis

How many episodes of Postgres FM are there?

Postgres FM launched 3 years ago and published 168 episodes to date. You can find more information about this podcast including rankings, audience demographics and engagement in our podcast database.

How do I contact Postgres FM?

Our systems regularly scour the web to find email addresses and social media links for this podcast. We scanned the web and collated all of the contact information that we could find in our podcast database. But in the unlikely event that you can't find what you're looking for, our concierge service lets you request our research team to source better contacts for you.

Where can I see ratings and reviews for Postgres FM?

Rephonic pulls ratings and reviews for Postgres FM from multiple sources, including Spotify, Apple Podcasts, Castbox, and Podcast Addict.

View all the reviews in one place instead of visiting each platform individually and use this information to decide if a show is worth pitching or not.

How do I access podcast episode transcripts for Postgres FM?

Rephonic provides full transcripts for episodes of Postgres FM. Search within each transcript for your keywords, whether they be topics, brands or people, and figure out if it's worth pitching as a guest or sponsor. You can even set-up alerts to get notified when your keywords are mentioned.

What guests have appeared on Postgres FM?

Recent guests on Postgres FM include:

1. Harry Brundage
2. Simon Eskildsen
3. Gwen Shapira
4. Lev Kokotov
5. Franck Pachot
6. Lukas Eder
7. Gülçin Yıldırım Jelínek
8. Robert Haas

To view more recent guests and their details, simply upgrade your Rephonic account. You'll also get access to a typical guest profile to help you decide if the show is worth pitching.

Find and pitch the right podcasts

We help savvy brands, marketers and PR professionals to find the right podcasts for any topic or niche. Get the data and contacts you need to pitch podcasts at scale and turn listeners into customers.
Try it free for 7 days