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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
