DB LLM Agents? | Scaling Postgres 382

In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a blue/green rollback.

Content Discussed

• From DBA to DB Agents
• Partitioned table statistics
• PostgreSQL 18 RC 1 Released!
• Primary keys in sharded databases
• PgDog adds support for Rust plugins
• Disks
• pg_tde can now encrypt your WAL on PROD!
• Who logged to system from multiple countries in 2 hours?
• Exploration: CNPG Kubectl Plugin
• Run Jepsen against CloudNativePG to see sync replication prevent data loss
• PG Down Under
• How I solved a distributed queue problem after 15 years
• LLM Rules for Postgres
• Highlights of PostgreSQL 18
• Best practices for securing PostgreSQL in hybrid environments
• The Hidden Bottleneck in PostgreSQL Restores and its Solution
• Automated PostgreSQL Backups in Docker: Complete Guide with pg_dump
• Maza and Baza: A Tale of GSoC'25 ABI Compliance Checker project
• GSoC'25 at PostgreSQL: Work and Results
• Contributions for the weeks 32 - 35 (2025-08-04 - 2025-08-28)
• PostgreSQL Conference Europe Is Here!
• PGConf.EU Community Events Day: CfPs closing soon
• Unit Testing PostgreSQL with pgTAP
• Featherlight Migrations: A Guide to the Tern Database Tool
• PostgreSQL Couldn’t Handle Our Time-Series Data—TimescaleDB Crushed It
• Automating Amazon RDS and Amazon Aurora recommendations via notification with AWS Lambda, Amazon EventBridge, and Amazon SES
• Accelerate database migration using virtual target mode in AWS DMS Schema Conversion
• How to Make the Most of Neon’s Free Plan
• Supabase Launch Week 15 Hackathon Winner Announcement

YouTube Video

Podcast Audio