|
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 |
