Обсуждение: pg_Restore
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 = 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
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 = 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
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
(1GBdumpfile) which has 500 schemas with 1 lakh rows in each schema. Could take the data dump using pg_dump and it
takesaround 40 minutes. I tried to use pg_restore to restore this dump, but it takes hours to restore the dump. I have
usedthe 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
configurationsare 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