Player FM - Internet Radio Done Right
75 subscribers
Checked 5d ago
Menambahkan seven tahun yang lalu
Konten disediakan oleh creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. Semua konten podcast termasuk episode, grafik, dan deskripsi podcast diunggah dan disediakan langsung oleh creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison atau mitra platform podcast mereka. Jika Anda yakin seseorang menggunakan karya berhak cipta Anda tanpa izin, Anda dapat mengikuti proses yang diuraikan di sini https://id.player.fm/legal.
Player FM - Aplikasi Podcast
Offline dengan aplikasi Player FM !
Offline dengan aplikasi Player FM !
Scaling Postgres
Tandai semua (belum/sudah) diputar ...
Manage series 2140130
Konten disediakan oleh creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. Semua konten podcast termasuk episode, grafik, dan deskripsi podcast diunggah dan disediakan langsung oleh creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison atau mitra platform podcast mereka. Jika Anda yakin seseorang menggunakan karya berhak cipta Anda tanpa izin, Anda dapat mengikuti proses yang diuraikan di sini https://id.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
527 episode
Tandai semua (belum/sudah) diputar ...
Manage series 2140130
Konten disediakan oleh creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. Semua konten podcast termasuk episode, grafik, dan deskripsi podcast diunggah dan disediakan langsung oleh creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison atau mitra platform podcast mereka. Jika Anda yakin seseorang menggunakan karya berhak cipta Anda tanpa izin, Anda dapat mengikuti proses yang diuraikan di sini https://id.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
527 episode
Semua episode
×S
Scaling Postgres

1 Postgres Conference 2025 | Scaling Postgres 358 23:37
23:37
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai23: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai9: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai15: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai15: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai15: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai15: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai14: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

1 Features To Avoid? | Scaling Postgres 351 16:55
16:55
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai16: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/…
S
Scaling Postgres

1 Seven Years of Scaling Postgres | Scaling Postgres 350 19:09
19:09
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai19: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai15: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai12: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai14: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai15: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai17: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
Putar Nanti
Putar Nanti
Daftar
Suka
Menyukai17: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/…
Selamat datang di Player FM!
Player FM memindai web untuk mencari podcast berkualitas tinggi untuk Anda nikmati saat ini. Ini adalah aplikasi podcast terbaik dan bekerja untuk Android, iPhone, dan web. Daftar untuk menyinkronkan langganan di seluruh perangkat.