Michael Clemmons wrote on 11.12.2009 23:52:
Thanks all this has been a good help. I don't have control(or easy control) over unit tests creating/deleting databases since Im using the django framework for this job. Createdb takes 12secs on my system(9.10 pg8.4 and ext4) which is impossibly slow for running 200unittests.
I wonder if you could simply create one database, and then a new schema for each of the tests. After creating the schema you could alter the search_path for the "unit test user" and it would look like a completely new database. Thomas -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
