Postgres Pro
Downloads
Home   >   mailing lists

Fastest Backup & Restore for perf testing - Mailing list pgsql-performance

From Wes Vaske (wvaske)
Subject Fastest Backup & Restore for perf testing
Date
Msg-id 31701C89A44B714FB8D242F806E7286C5AEC68FE@NTXBOIMBX01.micron.com
Whole thread Raw
Responses Re: Fastest Backup & Restore for perf testing  (Andrew Dunstan <andrew@dunslane.net>)
Re: Fastest Backup & Restore for perf testing  (Steve Atkins <steve@blighty.com>)
List pgsql-performance
Tree view

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

 

pgsql-performance by date:

Previous
From: Tory M Blue
Date:
Subject: ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881
Next
From: Andrew Dunstan
Date:
Subject: Re: Fastest Backup & Restore for perf testing