Super Jumbo Delux

on YouTube ↗58m

" summary

Argues that PostgreSQL is the go-to first tool for data warehousing before proprietary systems or MapReduce and shows concrete limits and wins: index-only scans in 9.2 speed covering-index queries, comfort degrades around ~10 terabytes so forks/specialty products matter, use SSDs and tablespaces for parallel I O, prefer COPY or PG bulk loader for fast loads, employ partitioning by inheritance with constraint exclusion for rolling-off data, use unlogged tables/temporary tables for ETL, window functions and materialized summaries for fast analytics.

AI-written summary · about

" chapters (8)

1. 0:00Start
2. 4:04data mining
3. 6:42dimension synonyms
4. 10:00Postgres does it all
5. 10:30Complex Queries
6. 23:23Extract, Transform, Load
7. 47:16Entity Attribute Value
8. 51:55Just Use Columns

" related talks

• 49mCan PostgreSQL Compete with Analytics Specialists?Lætitia Avrot · PostgreSQL Conference Europe 2025
• 48mData Horizons With PostgresBruce Momjian · Big Data Conference Europe 2022
• 27mBuilding a PostgreSQL data warehouseMarco Slot · POSETTE: An Event for Postgres 2025
• 56mBreakout SessionBruce Momjian · PGConf Silicon Valley 2015
• 46mUse PostgreSQL to Step Up Your GameEmmanuel Remy · Devoxx France 2023
• 25mData-intensive PostgreSQL: Three ways to scaleMarco Slot · POSETTE: An Event for Postgres 2024
• 29mPostgres DemystifiedCraig Kerstiens · MountainWest RubyConf 2013
• 59mUsing Postgres XLRichard Silva · PGConf Silicon Valley 2016