<div dir="ltr">Hello,<br /> <br />Greetings !<br />I am new to postgres and recently got migrated from oracle.<br />I
amtrying to restore 9.5G database (1GB dumpfile) which has 500 schemas with 1 lakh rows in each schema. Could take the
datadump using pg_dump and it takes around 40 minutes. I tried to use pg_restore to restore this dump, but it takes
hoursto restore the dump. I have used the configurations parameters as below:<br /> <br />shared_buffers = 1024MB <br
/>work_mem= 512MB<br />maintenance_work_mem = 512MB<br />wal_buffers = 100MB<br /> <br />I have used command to restore
asbelow:<br />pg_Restore -d newdb -j2 e:\file.dmp<br /> <br />My machine configurations are as below:<br />Windows Core
I5with 4GB Ram.<br /> <br />Thanks for your help.<br /> <br />Thanks and Regards<br />Radha Krishna<br /></div>