The Backend Engineering Show with Hussein Nasser
They Enabled Postgres Partitioning and their Backend fell apart
Jun 24, 2023
33:38
AI Summary
AI Chapters
Episode notes
Podcast summary created with Snipd AI
Quick takeaways
- Enabling partitioning in Postgres can significantly improve query performance by allowing queries to target specific partitions instead of the entire table.
- Lock manager weights in Postgres partitioning can cause application failures and delays in query performance, but this issue has been addressed and optimized in Postgres 14 for partitioned tables.
Deep dives
Postgres partitioning allows for efficient data management
Postgres partitioning enables the slicing of large tables into multiple partitions. This horizontal slicing improves query performance by allowing queries to target specific partitions instead of scanning the entire table. By working with smaller tables, queries become faster and more efficient.
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
