התחל במצב לא מקוון עם האפליקציה Player FM !
פודקאסטים ששווה להאזין
בחסות


1 72: If You Want to Grow—Stop Fixing the Wrong Problem 16:32
Extending Postgres for High-Performance Analytics (with Philippe Noël)
Manage episode 419638140 series 3476072
PostgreSQL is an incredible general-purpose database, but it can’t do everything. Every design decision is a tradeoff, and inevitably some of those tradeoffs get fundamentally baked into the way it’s built. Take storage for instance - Postgres tables are row-oriented; great for row-by-row access, but when it comes to analytics, it can’t compete with a dedicated OLAP database that uses column-oriented storage. Or can it?
Joining me this week is Philippe Noël of ParadeDB, who’s going to take us on a tour of Postgres’ extension mechanism, from creating custom functions and indexes to Rust code that changes the way Postgres stores data on disk. In his journey to bring Elasticsearch’s strengths to Postgres, he’s gone all the way down to raw datafiles and back through the optimiser to teach a venerable old dog some new data-access tricks.
–
ParadeDB: https://paradedb.com
ParadeDB on Twitter: https://twitter.com/paradedb
ParadeDB on Github: https://github.com/paradedb/paradedb
pgrx (Postgres with Rust): https://github.com/pgcentralfoundation/pgrx
Tantivy (Rust FTS library): https://github.com/quickwit-oss/tantivy
PgMQ (Queues in Postgres): https://tembo.io/blog/introducing-pgmq
Apache Datafusion: https://datafusion.apache.org/
Lucene: https://lucene.apache.org/
Kris on Mastodon: http://mastodon.social/@krisajenkins
Kris on LinkedIn: https://www.linkedin.com/in/krisjenkins/
Kris on Twitter: https://twitter.com/krisajenkins
93 פרקים
Manage episode 419638140 series 3476072
PostgreSQL is an incredible general-purpose database, but it can’t do everything. Every design decision is a tradeoff, and inevitably some of those tradeoffs get fundamentally baked into the way it’s built. Take storage for instance - Postgres tables are row-oriented; great for row-by-row access, but when it comes to analytics, it can’t compete with a dedicated OLAP database that uses column-oriented storage. Or can it?
Joining me this week is Philippe Noël of ParadeDB, who’s going to take us on a tour of Postgres’ extension mechanism, from creating custom functions and indexes to Rust code that changes the way Postgres stores data on disk. In his journey to bring Elasticsearch’s strengths to Postgres, he’s gone all the way down to raw datafiles and back through the optimiser to teach a venerable old dog some new data-access tricks.
–
ParadeDB: https://paradedb.com
ParadeDB on Twitter: https://twitter.com/paradedb
ParadeDB on Github: https://github.com/paradedb/paradedb
pgrx (Postgres with Rust): https://github.com/pgcentralfoundation/pgrx
Tantivy (Rust FTS library): https://github.com/quickwit-oss/tantivy
PgMQ (Queues in Postgres): https://tembo.io/blog/introducing-pgmq
Apache Datafusion: https://datafusion.apache.org/
Lucene: https://lucene.apache.org/
Kris on Mastodon: http://mastodon.social/@krisajenkins
Kris on LinkedIn: https://www.linkedin.com/in/krisjenkins/
Kris on Twitter: https://twitter.com/krisajenkins
93 פרקים
כל הפרקים
×
1 Beyond AI Hype, What Will Developers Actually Use? (with Zach Lloyd) 1:18:06

1 The $500 Billion Integration Problem, And One Possible Solution (with Marty Pitt) 1:31:33

1 Making Software Crash Before It Breaks (with Isaac Van Doren) 57:08

1 Making Apache Kafka Diskless (with Filip Yonov & Josep Prat) 1:29:29

1 Java's Cutting Edge Comeback (with Josh Long) 1:24:29

1 The State & Future of Apache Kafka (with Anatoly Zelenin) 1:12:22

1 DataFusion - The Database Building Toolkit (with Andrew Lamb) 1:32:10

1 Jupyter's Architecture Unpacked (with Afshin Darian & Sylvain Corlay) 1:29:11

1 Nix, The Build-Everything Language (with Julian Arni) 1:20:36

1 Graphite: Image Editing as a Syntax Tree (with Keavon Chambers & Dennis Kobert) 1:17:32

1 ReScript: A Better Typed JavaScript? (with Gabriel Nordeborn) 1:32:53

1 A universal query engine in Rust (with Predrag Gruevski) 1:15:31

1 Raspberry Pi Hardware & A Lisp Brain (with Dimitris Kyriakoudis) 1:34:43

1 Software Systems Aren't Just Software (with Diana Montalion) 1:50:14

1 Building Fyrox: A Rust Game Engine (with Dmitry Stepanov) 1:43:45
ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.