Click any tag below to further narrow down your results
Links
The article critiques the common practice of using "soft delete" with an archived_at column, citing complexities in queries, operations, and potential data bloat. It explores alternatives like application events, triggers, and change data capture to manage archived data more effectively.
The article discusses how to archive PostgreSQL partitions to Apache Iceberg, highlighting the benefits of using Iceberg for managing large datasets and improving query performance. It outlines the steps necessary for implementing this archiving process and emphasizes the efficiency gained through Iceberg's table format.