Schedule - PGConf.DE 2025
Data Archiving and Retention in PostgreSQL: Best Practices for Large Datasets
Date: 2025-05-09
Time: 11:10–11:55
Room: Ballsaal 3
Level: Intermediate
Large datasets can bloat PostgreSQL databases, slowing down performance and complicating management, especially when outdated data is left unmanaged. In this talk, I will explore practical strategies to efficiently archive and retain data, covering: • Partitioning: Simplifying table management and improving query performance with declarative partitioning. • Compression: Leveraging advanced techniques like pg_zstd to reduce storage costs. • Archiving Old Data: Moving stale or rarely-used data to external systems using Foreign Data Wrappers (FDWs). • Lifecycle Automation: Implementing retention policies to automatically archive or remove outdated data.
Attendees will gain actionable techniques to optimize performance, maintain compliance, and manage storage efficiently. This talk is ideal for both PostgreSQL users new to data retention and users dealing with growing datasets.