pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (15+ messages)  latest in thread

Message-ID: <opslyfkag4th1vuj@musicbox>
Permalink:  ../opslyfkag4th1vuj@musicbox/
Also on:    postgresql.org/message-id/opslyfkag4th1vuj@musicbox

 · 

reply

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