Re: speeding up table creation

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