Our development server currently has a file-based PostgreSQL server installed and running perfectly. However, we're trying to speed up our Rspec/Autotest runs and I was thinking that running a secondary in-memory version of Postgres might speed things up. And since we really don't care about losing the test data (it gets blown away at the beginning of every test anyway), we shouldn't need to sync it back to the filesystem or anything.
I read http://rhaas.blogspot.com/2010/06/postgresql-as-in-memory-only-database_24.html which talks about some of the configuration options you should use for performance, but I need a bit of help actually getting it set up.
How should I create the RAM disk and run a second version of Postgres?
I read somewhere that I can copy the init.d script and just pass a second configuration file. Is it that simple?