| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | bhanu udaya <udayabhanu1984(at)hotmail(dot)com> |
| Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: pg_Restore |
| Date: | 2013-01-20 21:42:54 |
| Message-ID: | 1358718174.2081.30.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
On Mon, 2013-01-21 at 00:03 +0530, bhanu udaya wrote:
> Hello, Greetings !I am new to postgres and recently got migrated from oracle.I am trying to restore 9.5G database (1GB dumpfile) which has 500 schemas with 1 lakh rows in each schema. Could take the data dump using pg_dump and it takes around 40 minutes. I tried to use pg_restore to restore this dump, but it takes hours to restore the dump. I have used the configurations parameters as below: shared_buffers = 1024MB work_mem = 512MBmaintenance_work_mem = 512MBwal_buffers = 100MB I have used command to restore as below:pg_Restore -d newdb -j2 e:\file.dmp My machine configurations are as below:Windows Core I5 with 4GB Ram. Thanks for your help. Thanks and RegardsRadha Krishna
You should better look for help on the pgsql-* mailing lists (for
example pgsql-general).
Anyway, from what you say, you should probably take a look at your
checkpoint settings. They probably hurt you more than you think.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bhanu udaya | 2013-01-21 04:10:08 | Re: pg_Restore |
| Previous Message | Guillaume Lelarge | 2013-01-20 21:36:57 | Re: Bug on pgAdmin III commit: Add a -V/--version CLI option? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2013-01-20 22:01:49 | Re: proposal: fix corner use case of variadic fuctions usage |
| Previous Message | Tom Lane | 2013-01-20 20:30:46 | Re: not(t_xmax = 0) |