Re: [PERFORM] speeding up table creation

2008-10-15 Thread Craig Ringer
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 th

Re: [PERFORM] speeding up table creation

2008-10-14 Thread Scott Marlowe
On Tue, Oct 14, 2008 at 5:08 PM, Rainer Mager <[EMAIL PROTECTED]> wrote: > 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 ru

Re: [PERFORM] speeding up table creation

2008-10-14 Thread Steve Crawford
Rainer Mager wrote: 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 p

[PERFORM] speeding up table creation

2008-10-14 Thread Rainer Mager
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 recre