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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
