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

Kirk Wolak <wolakk@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