bhanu udaya wrote: > I tried with all the below options. It approximatly takes 1 hour 30 minutes > for restoring a 9GB > database. This much time can not be affordable as the execution of test > cases take only 10% of this > whole time and waiting 1 hour 30 minutes after every test case execution is > alot for the team. Kindly > let me know if we can reduce the database restoration time .
I don't know if that helps, but have you tried creating a template database and doing DROP DATABASE xxx; CREATE DATABASE xxx TEMPLATE mytemplate; instead of restoring a dump every time? Maybe that is faster. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
