Rephonic
Artwork for Scaling Postgres

Scaling Postgres

Creston Jamison
Postgresql
Postgres
PG Vector
Performance Tuning
Postgresql 17
Postgresql 0.7.0
Database Management
Index Creation
Indexing Performance
Vector Embeddings
Query Performance
Mysql
Openai API
Database Backup Strategies
Elasticsearch
Postgresql Performance
Ottertune
Transactions Per Second
Wait Events
Performance Optimization

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.

PublishesWeeklyEpisodes407Founded8 years ago
Number of ListenersCategory
Technology

Listen to this Podcast

Artwork for Scaling Postgres

Latest Episodes

In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed clients, on conflict do select and all about Patroni.

To get the show notes as well as get notified of ne... more

YouTube

In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling.

To get the show notes as well as get notified of new episodes, visit: 

www... more

YouTube

In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how to maintain reading efficiency.

To get the show notes as well as get notified of new episodes, visit: 

h... more

YouTube

In this episode of Scaling Postgres, we discuss how the postmaster does not scale, new Postgres releases, data storage using PAX and a path generation strategies change.

To get the show notes as well as get notified of new episodes, visit: 

https://... more

YouTube

In this episode of Scaling Postgres, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_interval, checkpoint configuration, skip scans and more just use Postgres.

To get the show notes as well as g... more

YouTube

In this episode of Scaling Postgres, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse offers OLTP hosted Postgres and partition table source of truth.

To get the show notes as well as get notifie... more

YouTube

In this episode of Scaling Postgres, we discuss searching one billion vectors on Postgres, how to bypass a vector index search, unconventional optimizations and a 40x boost to listen/notify performance.

To get the show notes as well as get notified ... more

YouTube

In this episode of Scaling Postgres, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparound and AI or LLM index recommendations.

To get the show notes as well as get notified of new episodes, visit... more

YouTube

Key Facts

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.

Postgres FM
Postgres FMNikolay Samokhvalov and Michael Christofides
Talk Python To Me
Talk Python To MeMichael Kennedy
Python Bytes
Python BytesMichael Kennedy and Brian Okken
Syntax - Tasty Web Development Treats
Syntax - Tasty Web Development TreatsWes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Recent Guests

Lev Kokotov
Formerly of Instacart, now at PGDog, he speaks on scaling PostgreSQL challenges and solutions.
PGDog
Episode: Handle One Million Connections? | Scaling Postgres 360

Top Technology Podcasts

Acquired
AcquiredBen Gilbert and David Rosenthal
Hard Fork
Hard ForkThe New York Times
Tomorrow, Today
Tomorrow, TodayShekhar Natarajan
Dwarkesh Podcast
Dwarkesh PodcastDwarkesh Patel
Technology Now
Technology NowHewlett Packard Enterprise

Talking Points

Recent interactions between the hosts and their guests.

Millions of QPS | Scaling Postgres 402
Q: What do you use to maintain your source of record for your partition tables?
The host shares his method of building it into code that runs daily to create new tables, while mentioning tool options like PgPartman for managing partition configurations in database tables.

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 Scaling Postgres

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

Content primarily focuses on strategies, techniques, and challenges related to optimizing and scaling PostgreSQL databases. Topics frequently covered include performance tuning, scalability issues, and practical solutions to enhance database management. Listeners gain insights into specific PostgreSQL features and configurations, as well as best practices and recent advancements in the database ecosystem, such as handling high volumes of data, effective indexing strategies, and mitigation techniques for common problems like latency and index overhead. The unique emphasis on real-world applications and case studies makes it particularly beneficial for developers and database administrators looking to improve their systems' performance and ef... more

Where can I find podcast stats for Scaling Postgres?

Rephonic provides a wide range of podcast stats for Scaling Postgres. 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 Scaling Postgres and access YouTube viewership numbers, download stats, audience demographics, chart rankings, ratings, reviews and more.

How many listeners does Scaling Postgres get?

Rephonic provides a full set of podcast information for three million podcasts, including the number of listeners. View further listenership figures for Scaling Postgres, 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 Scaling Postgres?

Rephonic provides comprehensive predictive audience data for Scaling Postgres, 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 Scaling Postgres have?

To see how many followers or subscribers Scaling Postgres 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 Scaling Postgres?

These podcasts share a similar audience with Scaling Postgres:

1. Postgres FM
2. Talk Python To Me
3. Data Engineering Podcast
4. Python Bytes
5. Syntax - Tasty Web Development Treats

How many episodes of Scaling Postgres are there?

Scaling Postgres launched 8 years ago and published 407 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 Scaling Postgres?

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 Scaling Postgres?

Rephonic pulls ratings and reviews for Scaling Postgres 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 Scaling Postgres?

Rephonic provides full transcripts for episodes of Scaling Postgres. 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 Scaling Postgres?

Recent guests on Scaling Postgres include:

1. Lev Kokotov

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