Message-ID: <48F5953C.2010108@postnewspapers.com.au>
Date: Wed, 15 Oct 2008 15:01:16 +0800
From: Craig Ringer <craig@postnewspapers.com.au>
User-Agent: Thunderbird 2.0.0.17 (X11/20080925)
MIME-Version: 1.0
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Rainer Mager <rainer@vanten.com>,
	pgsql-performance@postgresql.org
Subject: Re: speeding up table creation
References: <000001c92e51$c42afcb0$4c80f610$@com>
	<48F531B9.9010302@pinpointresearch.com>
In-Reply-To: <48F531B9.9010302@pinpointresearch.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Steve Crawford wrote:

> You cannot keep the data in memory (that is, you can't disable writing 
> to the disk). But since you don't care about data loss, you could turn 
> off fsync in postgresql.conf. From a test perspective you should be fine 
> - it will only be an issue in the event of a crash and then you can just 
> restart with a fresh load. Remember, however, that any performance 
> benchmarks won't translate to production use (of course they don't 
> translate if you are using ramdisk anyway).

Another thing that may really help, if you're not already doing it, is 
to do all your schema creation inside a single transaction - at least 
assuming you can't use the template database approach.

--
Craig Ringer