| From: | "Wes Vaske (wvaske)" <wvaske(at)micron(dot)com> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Fastest Backup & Restore for perf testing |
| Date: | 2015-05-27 20:24:04 |
| Message-ID: | 31701C89A44B714FB8D242F806E7286C5AEC68FE@NTXBOIMBX01.micron.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
I'm running performance tests against a PostgreSQL database (9.4) with various hardware configurations and a couple different benchmarks (TPC-C & TPC-H).
I'm currently using pg_dump and pg_restore to refresh my dataset between runs but this process seems slower than it could be.
Is it possible to do a tar/untar of the entire /var/lib/pgsql tree as a backup & restore method?
If not, is there another way to restore a dataset more quickly? The database is dedicated to the test dataset so trashing & rebuilding the entire application/OS/anything is no issue for me-there's no data for me to lose.
Thanks!
Wes Vaske | Senior Storage Solutions Engineer
Micron Technology
101 West Louis Henna Blvd, Suite 210 | Austin, TX 78728
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2015-05-27 20:37:01 | Re: Fastest Backup & Restore for perf testing |
| Previous Message | Tory M Blue | 2015-05-27 07:50:51 | ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881 |