TPS Benchmark, Partition-wise Join, Partition Billions, Posgres 16 Features | Scaling Postgres 279 скачать в хорошем качестве

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: https://www.scalingpostgres.com/episo... 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? Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours... 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