| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 8.3 / 8.2.6 restore comparison |
| Date: | 2008-02-07 16:11:32 |
| Message-ID: | 20080207161132.GI5031@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
* Joshua D. Drake (jd(at)commandprompt(dot)com) wrote:
> Ergghh o.k. I am definitely missing something in the environment. By
> your numbers I should be well over 100GB restored at 2.5 hours. I am
> not. I am only 38GB in.
I'm guessing you've checked this, so don't shoot me if you have, but....
How was the "restore file" built? Does it create the indexes, primary
keys, FKs, whatever, before loading the data? That'd slow things down
tremendously.. Or if it's creating them while loading the data, there
would be large pauses while it's building the indexes...
Enjoy,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-02-07 16:19:26 | Re: PostgreSQL 8.4 development plan |
| Previous Message | Joshua D. Drake | 2008-02-07 15:55:17 | Re: 8.3 / 8.2.6 restore comparison |