Request a Demo
Home   >   mailing lists

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

From Tom Lane
Subject Re: PoC: pg_dump --filter-data (like Oracle Where Clause on RMAN for specific tables)
Date
Msg-id 615474.1755275838@sss.pgh.pa.us
Whole thread Raw
In response to PoC: pg_dump --filter-data (like Oracle Where Clause on RMAN for specific tables)  (Kirk Wolak <wolakk@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: index prefetching
Next
From: Tom Lane
Date:
Subject: Re: Improve hash join's handling of tuples with null join keys