From: | Lee Keel <lee(dot)keel(at)uai(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Large Database Restore |
Date: | 2007-05-17 13:19:08 |
Message-ID: | 76758090F8686C47A44B6FF52514A1D308C9BB86@hermes.uai.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am restoring a 51GB backup file that has been running for almost 26 hours.
There have been no errors and things are still working. I have turned fsync
off, but that still did not speed things up. Can anyone provide me with the
optimal settings for restoring a large database?
Thanks in advance!
Lee
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-05-17 13:19:30 | Re: Time Zone Error |
Previous Message | Peter Wilson | 2007-05-17 10:15:32 | Re: Windows Vista Support |