Re: 8.3 / 8.2.6 restore comparison
От | Joshua D. Drake |
---|---|
Тема | Re: 8.3 / 8.2.6 restore comparison |
Дата | |
Msg-id | 20080207084901.7fcf418a@jd-laptop обсуждение исходный текст |
Ответ на | Re: 8.3 / 8.2.6 restore comparison (Stephen Frost <sfrost@snowman.net>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: