| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | "Wes Vaske (wvaske)" <wvaske(at)micron(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Fastest Backup & Restore for perf testing |
| Date: | 2015-05-27 20:37:01 |
| Message-ID: | 55662AED.7020707@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 05/27/2015 04:24 PM, Wes Vaske (wvaske) wrote:
>
> 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!
>
Read all of this chapter.
<http://www.postgresql.org/docs/current/static/backup.html>
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Atkins | 2015-05-27 20:39:06 | Re: Fastest Backup & Restore for perf testing |
| Previous Message | Wes Vaske (wvaske) | 2015-05-27 20:24:04 | Fastest Backup & Restore for perf testing |