Rephonic
Artwork for Scaling Postgres

Scaling Postgres

Creston Jamison
Postgresql
Postgres
PG Vector
Performance Tuning
Postgresql 17
Postgresql 0.7.0
Index Creation
Database Management
Vector Embeddings
Indexing Performance
Query Performance
Mysql
Database Backup Strategies
Openai API
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.

PublishesWeeklyEpisodes404Founded8 years ago
Number of ListenersCategory
Technology

Listen to this Podcast

Artwork for Scaling Postgres

Latest Episodes

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

In this episode of Scaling Postgres, we discuss the overhead of indexes, a Postgres year in review, an intro to row locking and table renaming issues.

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

www.scalingpostgres... more

YouTube

In this episode of Scaling Postgres, we examine how latency impacts performance, naughty queries, bm25 indexes and how to quickly create database clones.

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

www.scalingpostg... more

YouTube

In this episode of Scaling Postgres, we discuss if vacuum is lying to you with regard to index cleanup, an agentic toolkit with MCP server, indexes getting corrupted after an upgrade and $50 Planetscale Metal.

To get the show notes as well as get no... 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.

This Day in AI Podcast
This Day in AI PodcastMichael Sharkey, Chris Sharkey
Django Chat
Django ChatWilliam Vincent and Carlton Gibson
Python Bytes
Python BytesMichael Kennedy and Brian Okken

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

Hosts

Nikolai
Host providing insights on PostgreSQL performance and administration with a focus on practical applications and improvements.
Unknown Host
Host of the show with contributions throughout various episodes, emphasizing database management strategies.

Top Technology Podcasts

Hard Fork
Hard ForkThe New York Times
Acquired
AcquiredBen Gilbert and David Rosenthal
Building AI Boston
Building AI BostonBuilding AI Boston
Better with Bourbon
Better with BourbonThe AI-Enabled Executive LLC
Dwarkesh Podcast
Dwarkesh PodcastDwarkesh Patel

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?

Focused primarily on PostgreSQL, this podcast provides an in-depth exploration of performance optimization and scaling strategies for users of varying experience levels. It addresses significant topics such as advancements in PostgreSQL features, the impact of AI on database management, and practical advice on data retention, workload balancing, and query optimization. Each episode combines expert insights, technical analysis, and practical applications, ensuring listeners are well-informed about the latest trends and best practices in database administration. Unique elements include interviews with industry experts, consultants, and snippets of real-world experiences that highlight both challenges and solutions in PostgreSQL management.

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. This Day in AI Podcast
2. No Priors: Artificial Intelligence | Technology | Startups
3. Django Chat
4. Python Bytes

How many episodes of Scaling Postgres are there?

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