From: Rainer Mager <rainer@vanten.com>
To: pgsql-performance@postgresql.org
Subject: speeding up table creation
Date: Wed, 15 Oct 2008 08:08:27 +0900
Message-ID: <000001c92e51$c42afcb0$4c80f610$@com> (raw)
I have an interesting performance improvement need. As part of the automatic
test suite we run in our development environment, we re-initialize our test
database a number of times in order to ensure it is clean before running a
test. We currently do this by dropping the public schema and then recreating
our tables (roughly 30 tables total). After that we do normal inserts, etc,
but never with very much data. My question is, what settings can we tweak to
improve performance is this scenario? Specifically, if there was a way to
tell Postgres to keep all operations in memory, that would probably be
ideal.
We actually tried running Postgres off of a RAM disk and this did help a
reasonable amount, but we're running under Windows and setting up the RAM
disk is a hassle and all of our developers would need to do it.
Any tips would be appreciated.
--Rainer
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: rainer@vanten.com
Subject: Re: speeding up table creation
In-Reply-To: <000001c92e51$c42afcb0$4c80f610$@com>
* 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