Re: PoC: pg_dump --filter-data <file> (like Oracle Where Clause on RMAN for specific tables)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kirk Wolak <wolakk(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Nikolay Samokhvalov <nik(at)postgres(dot)ai>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Pavlo Golub <Pavlo(dot)Golub(at)cybertec(dot)at>
Subject: Re: PoC: pg_dump --filter-data <file> (like Oracle Where Clause on RMAN for specific tables)
Date: 2025-08-15 16:37:18
Message-ID: 615474.1755275838@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kirk Wolak <wolakk(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-08-15 16:52:06 Re: Improve hash join's handling of tuples with null join keys
Previous Message Peter Geoghegan 2025-08-15 16:29:25 Re: index prefetching