PostgreSQL BI Performance & News from XL project

on YouTube ↗39m

" summary

Benchmarks show vanilla Postgres improves modestly across 9.1–9.5 (~20%), then gains 3× speed on 10GB with 9.6 parallelism (22 TPC‑H queries drop to ~2–3 minutes). At 100GB it still runs for hours. A distributed fork, Postgres‑XL, runs the same 3TB workload across eight nodes and cuts load/query time dramatically — about 5–6× faster on big queries and a 3TB load drops from ~79 hours on one server to ~12 hours on the cluster. Postgres‑XL tracks core releases (alpha2 on PG10) and supports partitioning, logical replication, and common tools.

AI-written summary · about

" chapters (13)

1. 0:00Introduction
2. 6:25PostgreSQL 96
3. 8:35PostgreSQL 100GB
4. 10:15How many terabytes
5. 13:45Postgres Excel
6. 15:42PostgreSQL Excel
7. 18:23PostgreSQL 10 Marriage
8. 19:53PostgreSQL Admin
9. 21:07Excel
10. 22:20ESA
11. 23:22Core Infrastructure Initiative
12. 25:13Performance Data on Excel
13. 30:50Conclusion

" related talks

• 59mUsing Postgres XLRichard Silva · PGConf Silicon Valley 2016
• 50mPerformance ArchaeologyTomáš Vondra · PostgreSQL Conference Europe 2024
• 29mPerformance Archaeology - 20 years of improvementsTomáš Vondra · POSETTE: An Event for Postgres 2025
• 50mSupersized Postgres: Postgres-XL for OLTP and Big Data AnalyticsMason Sharp · PostgresOpen 2014
• 34mPostgres 10, Performance, and YouGabe Enslein · RailsConf 2018
• 54mScaling out by distributing and replicating data in Postgres XCAshutosh Bapat · Postgres Open 2012
• 56mPerformance Improvements in PostgreSQL9 2Robert Haas · Postgres Open 2012
• 43mPostgreSQL in the cloud: Theory and PracticeJohn Melesky · Postgres Open 2012