Re: [PERFORM] Fastest Backup & Restore for perf testing

2015-05-28 Thread Jim Nasby
On 5/27/15 3:39 PM, Steve Atkins wrote: On May 27, 2015, at 1: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_re

Re: [PERFORM] Fastest Backup & Restore for perf testing

2015-05-27 Thread Steve Atkins
> On May 27, 2015, at 1: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 da

Re: [PERFORM] Fastest Backup & Restore for perf testing

2015-05-27 Thread Andrew Dunstan
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