show episodes
 
Artwork

1
Scaling Postgres

Creston Jamison

icon
Unsubscribe
icon
Unsubscribe
Weekly
 
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.
  continue reading
 
Artwork

1
Programmers Quickie

Software Engineering

icon
Unsubscribe
icon
Unsubscribe
Weekly+
 
Software Engineering Best Practices, System Design, High Scale, Algorithms, Math, Programming Languages, Statistics, Machine Learning, Databases, Front Ends, Frameworks, Low Level Machine Structure, Papers and Computing, Computer Science Book Reviews - Everything!
  continue reading
 
Artwork
 
Learn from your favorite indie hackers as they share hard-earned lessons and tall tales from their data model journeys! Brought to you by Xata — the only serverless data platform for PostgreSQL.
  continue reading
 
Artwork

1
Simple Talks

Louis Davidson

icon
Unsubscribe
icon
Unsubscribe
Monthly+
 
Simple Talks, a Redgate Software podcast, features hosts Louis Davidson, Steve Jones, Grant Fritchey, Ryan Booz and Kellyn Gorman as they discuss technology adoption, career stories, industry challenges and more. From database management and DevOps, to data security and programming techniques, it’s a must-listen for tech industry professionals and enthusiasts. www.red-gate.com/simple-talk/ www.red-gate.com/simple-talk/podcasts/
  continue reading
 
Artwork

1
Tech on the Rocks

Kostas, Nitay

icon
Unsubscribe
icon
Unsubscribe
Monthly+
 
Join Kostas and Nitay as they speak with amazingly smart people who are building the next generation of technology, from hardware to cloud compute. Tech on the Rocks is for people who are curious about the foundations of the tech industry. Recorded primarily from our offices and homes, but one day we hope to record in a bar somewhere. Cheers!
  continue reading
 
Artwork
 
Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at marathonus.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
  continue reading
 
Loading …
show series
 
In this episode, Dave Rubinstein interviews Heikki Linnakangas, co-founder of Neon, a company that provides Postgres solutions. They discuss: The factors that have contributed to adoption of PostgreSQL Why PostgreSQL has leapfrogged over MySQL in popularity What to expect in PostgreSQL 18
  continue reading
 
In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/364-scaling-for-high-volume/ Want to learn more about Postgres performance…
  continue reading
 
Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each. Here are some links to things they mentioned: synchronous_commit https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT synchronous_commit …
  continue reading
 
Steve Jones, Grant Fritchey and Ryan Booz discuss moving your code from one database platform to another, highlighting some of the real benefits and concerns that you need to be aware of. Download Redgate’s 2025 State of the Database Landscape report at www.red-gate.com/solutions/state-of-database-landscape/2025/?utm_source=youtube&utm_medium=socia…
  continue reading
 
In this episode, Jenna interviews Dean Coclin, senior director of Industry Strategy at DigiCert, about the recent vote by the CA/Browser Forum to shorten the lifespan of TLS certificates to 47 days by 2029. They discuss: The schedule for the changes and the gradual increments lifespans will shorten by The rationale behind shortening certificate lif…
  continue reading
 
In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster recovery. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/363-top-ten-postgres-dos-and-do…
  continue reading
 
Nikolay and Michael discuss managed service support — some tips on how to handle cases that aren't going well, tips for requesting features, whether to factor in support when choosing service provider, and whether to use one at all. Here are some links to things they mentioned: YugabyteDB’s new upgrade framework https://www.yugabyte.com/blog/postgr…
  continue reading
 
Summary In this episode, Gilad Kleinman, co-founder of Epsio, shares his unique journey from PHP development to low-level kernel programming and how that evolution led him to build an innovative incremental views engine. Gilad explains that Epsio tackles a common challenge in databases: making heavy, complex queries faster and more efficient throug…
  continue reading
 
In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/362-optimizing-for-time-series-data/ Want to learn more abo…
  continue reading
 
In this special solo episode, host Louis Davidson stays ā€˜full screen’ for the entire show and answers the very questions he asks of others! Where it all started, what tech he loves, the one obvious thing he loves to do outside of working with databases (which has been mentioned before)...it’s all covered here! Check out other Simple Talks episodes …
  continue reading
 
In this episode, Jenna Barron interviews Antje Barth, principal developer advocate for generative AI at AWS. They discuss: The skills that are becoming more important as AI adoption increases The emergence of the AI engineering role The trend of "vibe coding" Resources: Amazon Q Developer Episode transcript…
  continue reading
 
In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign keys. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/361-roadmap-to-scaling-postgres/ Wa…
  continue reading
 
Nikolay and Michael discuss time-series considerations for Postgres — including when it matters, some tips for avoiding issues, performance considerations, and more. Here are some links to things they mentioned: Time series data https://en.wikipedia.org/wiki/Time_series TimescaleDB https://github.com/timescale/timescaledb 13 Tips to Improve Postgre…
  continue reading
 
In this episode, Jenna Barron speaks with Emilio Salvador, vice president of strategy and developer relations at GitLab, about AI agents in software development. Key talking points include: How AI agents compare to traditional forms of automation in the software development process Challenges teams may face when implementing agents The impact AI ag…
  continue reading
 
In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on Kubernetes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/360-ha…
  continue reading
 
Nikolay and Michael are joined by Tomas Vondra to discuss single query performance cliffs — what they are, why they happen, some things we can do to make them less likely or less severe, and some potential improvements to Postgres that could help. Here are some links to things they mentioned: Tomas Vondra https://postgres.fm/people/tomas-vondra Whe…
  continue reading
 
The Redgate Advocates (Kellyn Gorman, Ryan Booz, Steve Jones, and Grant Fritchey) sat down at the PASS Summit last year and spent some time telling how they went from working directly in tech, to helping others work with tech - both inside and outside of Redgate and their products. Check out other Simple Talks episodes at https://rd.gt/3TJocZ9 Conn…
  continue reading
 
In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/359-trillions-of-row…
  continue reading
 
Nikolay and Michael are joined by Lev Kokotov to discuss PgDog — including whether or when sharding is needed, the origin story (via PgCat), what's already supported, and what's coming next. Here are some links to things they mentioned: Lev Kokotov https://postgres.fm/people/lev-kokotov PgDog https://github.com/pgdogdev/pgdog PgCat https://github.c…
  continue reading
 
In this episode, Jenna Barron interviews Simon Ritter, deputy CTO of Azul, about the six features in Java 24 he thinks are most exciting, including faster startup times for Java apps, improvements to the Stream Gatherers API, and more. Learn more about Java 24 here: https://sdtimes.com/java/java-24-is-now-available-with-release-of-stream-gatherers-…
  continue reading
 
In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly, at least from my perspective, the most well attended talks seemed to cover pg_vector, analytics involving duckdb and partitioning. To get the show notes as well as get notified of new epi…
  continue reading
 
Summary In this episode, Viktor Kessler shares his journey and insights from his extensive experience in data management—from building risk management systems and data warehouses to working as a solutions architect at MongoDB and Dremio, and now co-founding a startup. Initially exploring data mesh concepts, Viktor explains how real-world challenges…
  continue reading
 
Nikolay talks Michael through using cloud snapshots — how they can be used to reduce RTO for huge Postgres setups, also to improve provisioning time, and some major catches to be aware of. Here are some links to things they mentioned: Snapshots on RDS https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html pgBackRest https:/…
  continue reading
 
In this Coffee Chat episode, Louis sits down with Redgate Advocate Kellyn Gorman. Kellyn tells her origin story of becoming a leader in the data community, which is as inspiring as it is interesting, and the conversation also covers security (and the inherent trust issues data professionals have!), fact-checking ourselves, aging DBAs, Lego obsessio…
  continue reading
 
In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait events. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/357-postgres-best-practices/ Want to learn more about Po…
  continue reading
 
Nikolay 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.html Generalized Search Trees for Database Systems (Hellerstein, Naughton, Pfeffer) https://dsf.berkeley.edu/papers/vld…
  continue reading
 
In this episode, Jenna Barron interviews Martin Reynolds, field CTO of Harness, about the misalignment between developers and FinOps. The company recently did a report that backed up the claims that developers and FinOps aren't properly aligned, and they talk about some of the findings of that report. Some key points of discussion include: The fact…
  continue reading
 
In this episode of Scaling Postgres, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage of default partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/356-is-the-future-immutable/ Want to learn more about Postgres per…
  continue reading
 
Nikolay and Michael use a recent "best practices" article as a prompt — giving a few tips each on the topics mentioned, like schema design, performance, backups, and more. Here are some links to things they mentioned: 7 Crucial PostgreSQL Best Practices (recent blog post) https://speakdatascience.com/postgresql-best-practices ā€œDon't do thisā€ episod…
  continue reading
 
Summary In this episode, Apurva Mehta, co-founder and CEO of Responsive, recounts his extensive journey in stream processing—from his early work at LinkedIn and Confluent to his current venture at Responsive. He explains how stream processing evolved from simple event ingestion and graph indexing to powering complex, stateful applications such as s…
  continue reading
 
In this episode of Simple Talks, Louis, Steve, Kellyn and Grant get together to discuss the recently released State of the Database Landscape Report 2025, delving into topics around security, professional development and AI. Download the full report here: https://www.red-gate.com/solutions/state-of-database-landscape/2025/?utm_source=podcast&utm_me…
  continue reading
 
In this episode, Jenna Barron interviews Lukasz Karolewski, senior staff software engineer at LinkedIn, and Ajay Prakash, staff software engineer at LinkedIn, to talk about how they built a prompt engineering playground at LinkedIn to improve cross-team collaboration with non-technical teams. They discuss: Why they built the playground The choice t…
  continue reading
 
In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions, sharding to scale and connection counts. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/355-top-ten-analytics-with-pg_moonca…
  continue reading
 
Nikolay and Michael discuss the CREATE STATISTICS feature in Postgres — what it's for, how often it's used, and how to spot cases where it would help. Here are some links to things they mentioned: CREATE STATISTICS https://www.postgresql.org/docs/current/sql-createstatistics.html citext https://www.postgresql.org/docs/current/citext.html Statistics…
  continue reading
 
In this episode David Rubinstein interviews Eran Yahav, co-founder and CTO of Tabnine, about why its important to provide AI assistants with clean code. They discuss: The importance of defining organizational rules and best practices to guide the AI How to use AI-assisted refactoring to improve legacy codebases If organizations should apply KonMari…
  continue reading
 
In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing application of streaming changes and a query that filled a databases disks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/354-postgres-us-treasur…
  continue reading
 
In this episode, we chat with David Jayatillake, VP of AI at Cube, about semantic layers and their crucial role in making AI work reliably with data. We explore how semantic layers act as a bridge between raw data and business meaning, and why they're more practical than pure knowledge graphs. David shares insights from his experience at Delphi Lab…
  continue reading
 
This week's show is with "definitely not a folk music artist" Erik (with a k) Darling from Darling Data. Erik weaves a tale of a decidedly non-data focused start to his career, solving the same problems over and over, spicy foods, family life, all while dropping some great names along the way. https://sqlsaturday.com/2025-05-10-sqlsaturday1105/ X: …
  continue reading
 
Join SD Times news editor Jenna Barron for a panel discussion on DeepSeek and what developers need to know about this model that has been in the spotlight for the past few weeks. The conversation covers why DeepSeek has gained so much attention, what makes it different from other models, proper data security and hygiene practices for using DeepSeek…
  continue reading
 
Loading …

Quick Reference Guide

Listen to this show while you explore
Play