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

[Tom Lane]

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