> As a side note, I learned something very interesting for our developers
> here.
> We had been doing a drop database and then a reload off a db dump from
> our
> live server for test data. This takes 8-15 minutes depending on the
> server
> (the one above takes about 8 minutes). I learned through testing that I
> can
> use create database template some_other_database and make a duplicate in
> about 2.5 minutes. which is a huge gain for us. We can load a pristine
> copy,
> make a duplicate, do our testing on the duplicate, drop the duplicate and
> create a new duplicate in less then five mintes.
I think thats because postgres just makes a file copy from the template.
Thus you could make it 2x faster if you put the template in another
tablespace on another drive.