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.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to