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