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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
