Scaling Postgres Episode 234 Rust Extensions, Timescale vs. Postgres, Shard Uninterrupted, Data Flow

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

In this episode of Scaling Postgres, we discuss using rust for Postgres extensions, performance comparisons of TimescaleDB vs. Postgres, uninterrupted writes when sharding in Citus and the Postgres data flow.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:28 - PostgresML is Moving to Rust for our 2.0 Release
02:08 - PostgreSQL + TimescaleDB: 1000x Faster Queries, 90% Data Compression, and Much More
05:15 - Citus 11.1 shards your Postgres tables without interruption
06:52 - Postgres Data Flow
08:11 - PostgreSQL: Sequences vs. Invoice numbers
10:43 - PostgreSQL 14 Internals, Part III
11:07 - Fun With Postgres Functions
11:50 - What is LATERAL, what is it for, and how can one use it?
12:23 - Column lists in logical replication publications - an overview of this useful PostgreSQL feature
13:11 - Pipeline mode in Psycopg
14:12 - 5mins of Postgres E36: Optimizing Postgres query throughput in Python using pipeline mode and psycopg 3.1
14:30 - Using the Timescale gem with Ruby
14:57 - How to make Pgpool-II Leader Switchover Seamless on AWS - Updating Route Table
15:10 - Index maintenance
15:27 - Peter Smith
15:36 - Rubber Duck Dev Show Episode 59 | Rails & Postgres Scaling with Andrew Atkinson
15:55 - Outro

#postgres #postgresql

[dongwooklee]

I am always looking at your mailing list and video. :)