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
