On Thu, 7 Feb 2008 11:11:32 -0500
Stephen Frost <sfrost@snowman.net> wrote:
> * 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....
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
