Re: 8.3 / 8.2.6 restore comparison - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: 8.3 / 8.2.6 restore comparison
Date
Msg-id 20080207161132.GI5031@tamriel.snowman.net
Whole thread Raw
In response to Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
* Joshua D. Drake (jd@commandprompt.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

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 / 8.2.6 restore comparison
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.4 development plan