The Cost of Arrays | Scaling Postgres 400

In this episode of Scaling Postgres, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparound and AI or LLM index recommendations.

Content Discussed

• The hidden cost of PostgreSQL arrays
• Dealing with integer overflow in sequence-generated primary keys
• Idle Session Triggers a Transaction Wraparound?
• Database Transactions
• PostgreSQL as a Graph Database: Who Grabbed a Beer Together?
• Why AI Workloads Are Fueling a Move Back to Postgres
• Custom Properties for PostgreSQL Database Objects Without Core Patches
• Optimizing data throughput for Postgres snapshots with batch size auto-tuning
• PostgreSQL Contributor Story: Mark Wong
• Updating CloudNativePG's documentation
• Stand Up, Mentor! Help Postgres Shine in GSoC 2026!
• PgPedia Week, 2025-12-14
• PgPedia Week, 2025-12-21
• PgPedia Week, 2025-12-28
• Announcing the second PostgreSQL Edinburgh meetup
• pg_statviz 0.9 released with new features
• Top 9 PostgreSQL Extensions Used by Tiger Data Customers in 2026
• Summary of PostgreSQL in the year 2025
• Contributions to PostgreSQL by HexaCluster in 2025
• Extended 100 day retention in pganalyze, and the new storage format that made it work
• Mission Impossible: How We Recovered 1TB of Data in 48 Hours
• AWS Organizations now supports upgrade rollout policy for Amazon Aurora and Amazon RDS automatic minor version upgrades
• Zero-ETL lakehouses for Postgres people
• Introducing TRAE SOLO integration with Supabase

YouTube Video

Podcast Audio