On Thursday 14 May 2009 20.19:53 Matt Wilson wrote: > > You should really run your tests with an in-memory sqlite database. > > They will be much faster. > > I really wish I could run my tests with an in-memory sqlite database, > but until sqlite supports stuff like the OVERLAPS keyword and time > intervals, I have to use postgres. I get lots of operational errors > now when I try to build my tables in sqlite.
Have you tested how much you can accelerate stuff when you run the testdatabase in a tablespace on a ramdisk? (Not sure: does pg keep the WAL in the same dir as the tablespace?) May be worth it even if it's a bit more work to set up. cheers -- vbi -- featured link: Debian Bookmark Collection - http://bookmarks.debian.net/
signature.asc
Description: This is a digitally signed message part.
