Re: 8.3 / 8.2.6 restore comparison

On Thu, 7 Feb 2008 11:11:32 -0500
Stephen Frost <sfrost(at)snowman(dot)net> wrote:

> * 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....

Uhh yeah :)

>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...
>

Absolutely correct. it would. This dump was created using pg_dumpall.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit