30K Messages Per Second Queue | Scaling Postgres 295

Рет қаралды 968

Күн бұрын

To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss a 30K messages per second queue built on Postgres, a zero downtime logical replication upgrade, the release of the Supavisor 1.0 connection pooler and PostGIS day.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:17 - Yeeting over 30k messages per second on Postgres with Tembo MQ
04:16 - pgmq on GitHub
04:36 - Zero downtime Postgres upgrades
08:38 - Supavisor 1.0: a scalable connection pooler for Postgres
10:35 - PostGIS Day 2023 Summary
10:54 - Updates on trademark actions against the PostgreSQL community
11:19 - A Sneak Peek Into the State of PostgreSQL 2023
12:56 - Constraints
13:22 - Understand Table Statistics Using pg_stat_all_tables
14:12 - Specialized Cpu Instructions15:06 - Outro
#postgres #postgresql

Пікірлер: 8

@jaimeduncan6167 7 ай бұрын

Keep up the good work. I need more promotion of this channel. These videos are full of good information and resources. I don't know if the PG community is too old to be looking at videos or if we are really so few. I will expect at least 50K subscribers.

@ScalingPostgres 7 ай бұрын

Thanks! I think the PG community (those who dedicate time to understand it) is on the smaller side. What amazes me is the number of people / engineers who use Postgres, but don't dedicate time to understanding it / learning more about it.

@sabriaouani6991 7 ай бұрын

I'm amazed with your consistency, you've been consistent for 5 years. woow, respect man 🎉

@ScalingPostgres 7 ай бұрын

Thanks! I do take some time off for the holidays on occasion. Hehe.

@sabriaouani6991 7 ай бұрын

@@ScalingPostgres you're kind of people I can look up too, If you need someone to work with you as Data analyst, please let me know. I will be honered to have you as a mentor

@ramanefira 7 ай бұрын

nice content!

@ScalingPostgres 6 ай бұрын

Thanks!

@jirehla-ab1671 10 күн бұрын

@@ScalingPostgres if I were to add a mesage que for real time OLTP database workloads, would that also induce latency which makes the OLTP database workload not in real time anymore? if so then whats the point of message queues then if its going to be used in real time OLTP database workloads?