On Fri, Aug 15, 2025 at 12:37 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Kirk Wolak <wol...@gmail.com> writes: > > We have a handful of tables that have 90% of the data going back 30 > years. > > We NEVER restore this data to Dev or Staging. We used a special RMAN > > backup where these tables had a "WHERE clause" applied to them during the > > backup/dump process. > > Have you considered partitioning these tables by date and then not > dumping the older partitions? That would fit into existing > functionality a lot better. > > regards, tom lane > I had not considered it until now. But because we are talking about only keeping 7 - 28 days of decades of data. I would assume that window would require a bit of work in production to maintain, making it a tough sell to the client.
