| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "bhanu udaya *EXTERN*" <udayabhanu1984(at)hotmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | François Beausoleil <francois(at)teksol(dot)info>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_Restore |
| Date: | 2013-01-21 11:39:00 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B0579BFDF@ntex2010a.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin French | 2013-01-21 11:46:37 | Re: Editable resultset |
| Previous Message | Dave Page | 2013-01-21 11:08:14 | Re: Editable resultset |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dinesh kumar | 2013-01-21 12:15:35 | Re: pg_Restore |
| Previous Message | Richard Huxton | 2013-01-21 11:12:39 | Re: Running update in chunks? |