Re: pg_Restore

Hello,

Greetings !
I am new to postgres and recently got migrated from oracle. I am using postgresql 9.2 version.
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 = 512MB
maintenance_work_mem = 512MB
wal_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 Regards
Radha Krishna