Player FM - Internet Radio Done Right
60 subscribers
Checked 4d ago
Added seven years ago
Content provided by creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!
Go offline with the Player FM app!
Podcasts Worth a Listen
SPONSORED
T
The Global Story


1 The dark memes behind Charlie Kirk’s murder 24:04
24:04
Play Later
Play Later
Lists
Like
Liked24:04
The assassination of conservative commentator Charlie Kirk shocked America and exposed the depth of its political divides. Since a suspect has been arrested, the search for clear motive has only become more complicated. In today’s episode, the BBC’s Social Media investigations correspondent Marianna Spring examines the meaning of the inscriptions on the bullet casings associated with the murder. The markings take us into the dark corners of the internet, but what do they tell us about why Charlie Kirk was killed? Producers: Cat Farnsworth, Aron Keller and Lucy Pawle Executive producer: Annie Brown Mix: Travis Evans Senior news editor: China Collins Image: Utah Governor Spencer Cox. Cheney Orr/Reuters…
Scaling Postgres
Mark all (un)played …
Manage series 2140130
Content provided by creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
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
548 episodes
Mark all (un)played …
Manage series 2140130
Content provided by creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
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
548 episodes
All episodes
×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/…
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/…
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/…

1 Storage Engine Progress? | Scaling Postgres 380 14:53
14:53
Play Later
Play Later
Lists
Like
Liked14: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/…

1 Unconventional Advice? | Scaling Postgres 379 19:03
19:03
Play Later
Play Later
Lists
Like
Liked19: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/…

1 Native Column Store? | Scaling Postgres 378 19:29
19:29
Play Later
Play Later
Lists
Like
Liked19: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/…

1 Sharding At Network Speeds | Scaling Postgres 377 15:14
15:14
Play Later
Play Later
Lists
Like
Liked15: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/…

1 100K Events Per Second Queue | Scaling Postgres 376 19:45
19:45
Play Later
Play Later
Lists
Like
Liked19: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/…
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/…

1 Migrating Millions Of Databases | Scaling Postgres 374 18:34
18:34
Play Later
Play Later
Lists
Like
Liked18: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/…

1 Planetscale Postgres! | Scaling Postgres 373 14:22
14:22
Play Later
Play Later
Lists
Like
Liked14: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/…

1 The Future of Postgres Architecture | Scaling Postgres 372 19:26
19:26
Play Later
Play Later
Lists
Like
Liked19: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/…

1 Are You Hurting Your Performance? | Scaling Postgres 371 21:08
21:08
Play Later
Play Later
Lists
Like
Liked21: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/…

1 New Scale Out Options | Scaling Postgres 370 14:51
14:51
Play Later
Play Later
Lists
Like
Liked14: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/…
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/…
S
Scaling Postgres

1 4 Times Faster UUID Primary Keys | Scaling Postgres 368 19:10
19:10
Play Later
Play Later
Lists
Like
Liked19:10
In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/368-4-times-faster-uuid-primary-keys/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 How Often Does That Query Run? | Scaling Postgres 367 13:10
13:10
Play Later
Play Later
Lists
Like
Liked13:10
In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/367-how-often-does-that-query-run/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 20,000 Times Faster Order By Limit | Scaling Postgres 366 14:46
14:46
Play Later
Play Later
Lists
Like
Liked14:46
In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit issue. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/366-20k-faster-order-by-limit/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Here Comes Async I/O! | Scaling Postgres 365 20:01
20:01
Play Later
Play Later
Lists
Like
Liked20:01
In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/365-here-comes-async-io/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Scaling For High Volume | Scaling Postgres 364 20:39
20:39
Play Later
Play Later
Lists
Like
Liked20:39
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? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Top Ten Postgres Dos & Don'ts | Scaling Postgres 363 13:32
13:32
Play Later
Play Later
Lists
Like
Liked13:32
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-donts/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Optimizing For Time-Series Data | Scaling Postgres 362 12:22
12:22
Play Later
Play Later
Lists
Like
Liked12:22
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 about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 A Roadmap To Scaling Postgres | Scaling Postgres 361 17:28
17:28
Play Later
Play Later
Lists
Like
Liked17:28
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/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Handle One Million Connections? | Scaling Postgres 360 16:17
16:17
Play Later
Play Later
Lists
Like
Liked16:17
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-handle-one-million-connections/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Trillions of Rows & Metrics | Scaling Postgres 359 18:27
18:27
Play Later
Play Later
Lists
Like
Liked18:27
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-rows-and-metrics/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Postgres Conference 2025 | Scaling Postgres 358 23:37
23:37
Play Later
Play Later
Lists
Like
Liked23:37
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 episodes, visit: https://www.scalingpostgres.com/episodes/358-postgres-conference-2025/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Postgres Best Practices? | Scaling Postgres 357 9:58
9:58
Play Later
Play Later
Lists
Like
Liked9:58
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 Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Is the Future Immutable? | Scaling Postgres 356 15:21
15:21
Play Later
Play Later
Lists
Like
Liked15:21
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 performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Top Ten Analytics with pg_mooncake | Scaling Postgres 355 15:59
15:59
Play Later
Play Later
Lists
Like
Liked15:59
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_mooncake/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 Postgres & The US Treasury Attack | Scaling Postgres 354 15:43
15:43
Play Later
Play Later
Lists
Like
Liked15:43
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-treasury-attack/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…
S
Scaling Postgres

1 OLTP To Parquet For Analytics | Scaling Postgres 353 15:59
15:59
Play Later
Play Later
Lists
Like
Liked15: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/…
S
Scaling Postgres

1 You Can Always Optimize More | Scaling Postgres 352 14:32
14:32
Play Later
Play Later
Lists
Like
Liked14: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/…
S
Scaling Postgres

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/…
S
Scaling Postgres

1 Seven Years of Scaling Postgres | Scaling Postgres 350 19:09
19:09
Play Later
Play Later
Lists
Like
Liked19: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/…
S
Scaling Postgres

1 The Dangers of Temporary Tables | Scaling Postgres 349 15:24
15:24
Play Later
Play Later
Lists
Like
Liked15: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/…
S
Scaling Postgres

1 The Future Is Containers? | Scaling Postgres 348 12:28
12:28
Play Later
Play Later
Lists
Like
Liked12: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/…
S
Scaling Postgres

1 Easy Incremental Data Processing? | Scaling Postgres 347 14:47
14:47
Play Later
Play Later
Lists
Like
Liked14: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/…
S
Scaling Postgres

1 Things I Don't Do In Postgres | Scaling Postgres 346 15:47
15:47
Play Later
Play Later
Lists
Like
Liked15: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/…
S
Scaling Postgres

1 Over 5X Faster Postgres? | Scaling Postgres 345 17:02
17:02
Play Later
Play Later
Lists
Like
Liked17: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/…
S
Scaling Postgres

1 Performance & Hard Things | Scaling Postgres 344 17:38
17:38
Play Later
Play Later
Lists
Like
Liked17: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/…
S
Scaling Postgres

1 Postgres Release Warning! | Scaling Postgres 343 18:50
18:50
Play Later
Play Later
Lists
Like
Liked18: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/…
S
Scaling Postgres

1 Faster Writes With ZFS? | Scaling Postgres 342 13:19
13:19
Play Later
Play Later
Lists
Like
Liked13: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/…
S
Scaling Postgres

1 The Future of Postgres Upgrades | Scaling Postgres 341 14:15
14:15
Play Later
Play Later
Lists
Like
Liked14: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/…
S
Scaling Postgres

1 Do You Need A Vectorizer? | Scaling Postgres 340 16:39
16:39
Play Later
Play Later
Lists
Like
Liked16: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/…
S
Scaling Postgres

1 Postgres Goes Parquet | Scaling Postgres 339 11:32
11:32
Play Later
Play Later
Lists
Like
Liked11: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/…
Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.