From: PFC <lists@boutiquenumerique.com>
To: Chris Kratz <chris.kratz@vistashare.com>
To: John Arbash Meinel <john@arbash-meinel.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Tuning
Date: Thu, 10 Feb 2005 00:58:48 +0100
Message-ID: <opslyfkag4th1vuj@musicbox> (raw)
In-Reply-To: <200502091625.34787.chris.kratz@vistashare.com>
References: <200502091501.31447.chris.kratz@vistashare.com>
<420A74BE.8010009@arbash-meinel.com>
<200502091625.34787.chris.kratz@vistashare.com>
> As a side note, I learned something very interesting for our developers
> here.
> We had been doing a drop database and then a reload off a db dump from
> our
> live server for test data. This takes 8-15 minutes depending on the
> server
> (the one above takes about 8 minutes). I learned through testing that I
> can
> use create database template some_other_database and make a duplicate in
> about 2.5 minutes. which is a huge gain for us. We can load a pristine
> copy,
> make a duplicate, do our testing on the duplicate, drop the duplicate and
> create a new duplicate in less then five mintes.
I think thats because postgres just makes a file copy from the template.
Thus you could make it 2x faster if you put the template in another
tablespace on another drive.
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: lists@boutiquenumerique.com, chris.kratz@vistashare.com, john@arbash-meinel.com
Subject: Re: Performance Tuning
In-Reply-To: <opslyfkag4th1vuj@musicbox>
* 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