100 TB and Beyond! | Scaling Postgres 320

Scaling Postgres

Player FM - Internet Radio Done Right

60 subscribers

הוסף לפני seven שנים

תוכן מסופק על ידי creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

Disrupting Peace

1
Why Listening is the First Step to Peace 36:28

לפני 10 ימים36:28

הפעל מאוחר יותר

רשימות

לייק

אהבתי

36:28

This season we’re looking at the first steps everyday people can take towards peace. And we’re kicking things off by zooming in to something direct and personal that people engage with every day: listening. How can “generous” listening contribute to peace, and what are practical ways to get started? In this episode, we explore concrete ways to have difficult conversations instead of violent reactions, and how our everyday interactions can ladder up to structural change. Naomi Boase is Tufts University’s inaugural Inclusive and Restorative Dialogues Program Director. She has provided DEI consultations and trainings in the US and abroad for over 10 years. The goal of these trainings is to increase a sense of belonging within communities and organizations. Find out more about Noami’s work here . Jonathan Tirrell is director of the Generous Listening and Dialogue Initiative at Tufts University. Trained as a developmental scientist, he studies positive youth development (PYD), seeking to understand how people become good people. Find out more about Jonathan’s work here . Disrupting Peace is a production of The World Peace Foundation. The show is produced by Bridget Conley and Emily Shaw. Engineering by Jacob Winik and Aja Simpson. Marketing and Social media by Emily Ruhm. Show artwork by Simon Fung. Special thanks to Jeremy Helton, Lisa Avery, B. Arneson, and Alex de Waal, and the team from the Tufts Digital Design Studio, including Kimberly Lynn Forero-Arnias, and Miles Donovan. Find out more about the World Peace Foundation at worldpeacefoundation.org . Follow us on Bluesky at worldpeacefdtn.bsky.social , and on Instagram at @worldpeacefdtn .…

לפני שנה 17:32

MP3•בית הפרקים

In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions

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

https://www.scalingpostgres.com/episodes/320-100tb-and-beyond/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

548 פרקים

#Ruby Tree Software Inc #Creston Jamison #Web Development #Tech #Software Development

Scaling Postgres

100 TB and Beyond! | Scaling Postgres 320

Scaling Postgres

60 subscribers

published לפני שנה

שתפו

MP3•בית הפרקים

In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions

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

https://www.scalingpostgres.com/episodes/320-100tb-and-beyond/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

548 פרקים

#Ruby Tree Software Inc #Creston Jamison #Web Development #Tech #Software Development

כל הפרקים

Scaling Postgres

1
OrioleDB More Free? | Scaling Postgres 383 13:20

לפני 4 ימים13:20

13:20

In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods resolve to slow order by limit queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/383-orioledb-more-free/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
DB LLM Agents? | Scaling Postgres 382 19:03

לפני 11 ימים19:03

19:03

In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a blue/green rollback. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/382-db-llm-agents/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
DocumentDB Movement | Scaling Postgres 381 9:44

לפני 18 ימים9:44

9:44

In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/381-documentdb-movement/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Storage Engine Progress? | Scaling Postgres 380 14:53

לפני 25 ימים14:53

14:53

In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/380-storage-engine-progress/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Unconventional Advice? | Scaling Postgres 379 19:03

לפני 5 weeks19:03

19:03

In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing performance optimizations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/379-unconventional-advice/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Native Column Store? | Scaling Postgres 378 19:29

לפני 6 weeks19:29

19:29

In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/378-native-column-store/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Sharding At Network Speeds | Scaling Postgres 377 15:14

לפני 7 weeks15:14

15:14

In this episode of Scaling Postgres, we discuss how to shard your DB at network speeds, how to make your DB 42,000 slower, new monitoring and just enough text searching performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/377-sharding-at-network-speeds/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
100K Events Per Second Queue | Scaling Postgres 376 19:45

לפני 8 weeks19:45

19:45

In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXact ID and space overrun and struggles starting Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/376-100k-events-per-second-queue/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
All The Benchmarks | Scaling Postgres 375 16:19

לפני 9 weeks16:19

16:19

In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and a deep dive into Multigres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/375-all-the-benchmarks/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Migrating Millions Of Databases | Scaling Postgres 374 18:34

לפני 10 weeks18:34

18:34

In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication slots. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/374-migrating-millions-of-databases/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Planetscale Postgres! | Scaling Postgres 373 14:22

לפני 11 weeks14:22

14:22

In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are optimal, avoiding UUIDv4 and the summer of upgrade report. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/373-planetscale-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
The Future of Postgres Architecture | Scaling Postgres 372 19:26

לפני 12 weeks19:26

19:26

In this episode of Scaling Postgres, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in the new SQL standard and one way to perform a blue-green deployment rollback in AWS RDS. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/372-the-future-of-postgres-architecture/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Are You Hurting Your Performance? | Scaling Postgres 371 21:08

לפני 13 weeks21:08

21:08

In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different upgrade methods. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/371-are-you-hurting-your-performance/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
New Scale Out Options | Scaling Postgres 370 14:51

לפני 14 weeks14:51

14:51

In this episode of Scaling Postgres, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting started with logical replication and a summer of upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/370-new-scale-out-options/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Move Off Of RDS? | Scaling Postgres 369 18:01

לפני 15 weeks18:01

18:01

In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate to partition tables. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/369-move-off-of-rds/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
OLTP To Parquet For Analytics | Scaling Postgres 353 15:59

לפני 31 weeks15:59

15:59

In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and partitioning advice. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/353-oltp-to-parquet-for-analytics/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
You Can Always Optimize More | Scaling Postgres 352 14:32

לפני 32 weeks14:32

14:32

In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/352-you-can-always-optimize-more/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Features To Avoid? | Scaling Postgres 351 16:55

לפני 33 weeks16:55

16:55

In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a way to detect a table rewrite and a zero downtime upgrade. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/351-features-to-avoid/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Seven Years of Scaling Postgres | Scaling Postgres 350 19:09

לפני 34 weeks19:09

19:09

In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/350-seven-years-of-scaling-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
The Dangers of Temporary Tables | Scaling Postgres 349 15:24

לפני 35 weeks15:24

15:24

In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock considerations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/349-the-dangers-of-temporary-tables/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
The Future Is Containers? | Scaling Postgres 348 12:28

לפני 36 weeks12:28

12:28

In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/348-the-future-is-containers/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Easy Incremental Data Processing? | Scaling Postgres 347 14:47

לפני 39 weeks14:47

14:47

In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, handling alter table retries and large object dump performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/347-easy-incremental-data-processing/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Things I Don't Do In Postgres | Scaling Postgres 346 15:47

לפני 40 weeks15:47

15:47

In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or create 7+ millions tables in a database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/346-things-i-do-not-do-in-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Over 5X Faster Postgres? | Scaling Postgres 345 17:02

לפני 41 weeks17:02

17:02

In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should us track_planning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/345-over-5x-faster-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Performance & Hard Things | Scaling Postgres 344 17:38

לפני 42 weeks17:38

17:38

In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/344-performance-hard-things/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Postgres Release Warning! | Scaling Postgres 343 18:50

לפני 43 weeks18:50

18:50

In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2X, pg_search benchmarks and fast OpenStreetMap loading. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/343-postgres-release-warning/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Faster Writes With ZFS? | Scaling Postgres 342 13:19

לפני 44 weeks13:19

13:19

In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new pgvector release. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/342-faster-writes-with-zfs/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
The Future of Postgres Upgrades | Scaling Postgres 341 14:15

לפני 45 weeks14:15

14:15

In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/341-the-future-of-postgres-upgrades/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Do You Need A Vectorizer? | Scaling Postgres 340 16:39

לפני 46 weeks16:39

16:39

In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan and advanced psql. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/340-do-you-need-a-vectorizer/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Postgres Goes Parquet | Scaling Postgres 339 11:32

לפני 47 weeks11:32

11:32

In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bounties, and Postgres gotchas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/339-postgres-goes-parquet/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

ברוכים הבאים אל Player FM!

Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.