On Thu, 7 Feb 2008 11:11:32 -0500 Stephen Frost <[EMAIL PROTECTED]> wrote:
> * Joshua D. Drake ([EMAIL PROTECTED]) 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
signature.asc
Description: PGP signature