TPS Benchmark, Partition-wise Join, Partition Billions, Posgres 16 Features | Scaling Postgres 279

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

In this episode of Scaling Postgres, we discuss how pgbouncer can impact a TPS benchmark, partition-wise join & aggregate performance, partitioning a table with billions of rows and cool Postgres 16 features.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
01:52 - EDB Postgres Advanced Server 15 TPS Benchmark
05:36 - How Partition-wise joins and aggregates improve query performance
06:50 - Presenting 'Partitioning Billions of Rows' at SFPUG August 2023
08:26 - Postgres V16: 14 Cool New Features
11:01 - Self-Managing
11:34 - PGSQL Phriday #012: What Excites You About PostgreSQL 16
11:51 - Introducing pg_later: Asynchronous Queries for Postgres, Inspired by Snowflake
12:43 - Postgres Subquery Powertools: CTEs. Materialized Views. Window Functions, and LATERAL Join
14:56 - The State of the Database Landscape
15:12 - Configuring PostgreSQL and LDAP Using StartTLS
15:34 - Outro

#postgres #postgresql

[awksedgreep]

Such a valuable resource. Thank you for creating this channel.

[MariuszKlinikowski]

First comment to tune up the YT algorithm.