From: Andrew Dunstan <andrew@dunslane.net>
To: Wes Vaske (wvaske) <wvaske@micron.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Fastest Backup & Restore for perf testing
Date: Wed, 27 May 2015 16:37:01 -0400
Message-ID: <55662AED.7020707@dunslane.net> (raw)
In-Reply-To: <31701C89A44B714FB8D242F806E7286C5AEC68FE@NTXBOIMBX01.micron.com>
References: <31701C89A44B714FB8D242F806E7286C5AEC68FE@NTXBOIMBX01.micron.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andrew@dunslane.net, wvaske@micron.com
Subject: Re: Fastest Backup & Restore for perf testing
In-Reply-To: <55662AED.7020707@dunslane.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox