On Tuesday, January 27, 2026, Gus Spier <[email protected]> wrote: > Environment: AWS RDS Aurora for PostgreSQL 15 hosting tables that > support scientific research. The development environment predominantly > uses JPA with Hibernate. > > Years of neglect have allowed mission tables to accumulate hundreds of > millions of rows of excess data. The developers and the customer > decided we must delete all rows older than 75 days. Table partitioning > was briefly considered but discarded because of the effort needed to > refactor the codebase. > > I proposed the straight-forward course of action: delete by batches > from the victim tables. > > Strongly encourage you to try to accomplish your goal without any delete commands at that scale that causes vacuuming. Can you just create an empty copy and load the data to keep into it then point at the newly filled database? Truncate is OK.
Daily trimming going forward would be less problematic at least. David J.
