Re: Surprise :-(

Поиск
Список
Период
Сортировка
От Jason Earl
Тема Re: Surprise :-(
Дата
Msg-id 87r8g63d86.fsf@npa01zz001.simplot.com
обсуждение исходный текст
Ответ на Re: Surprise :-(  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
Список pgsql-general
"Mihai Gheorghiu" <tanethq@earthlink.net> writes:

> Only one of the 350k trxtype=MP records has isposted=false !!!
> I am downloading 7.2.2 right now, and, God willing, on Monday I will be able
> to apply your recommendations regarding explain analyze.
> Which leads me to the following question:
> I dump this database with pgdump in less than 15 minutes and restore it with
> psql -d mydata -f mydata.dmp in 375 minutes.
> Is there a faster way?
> Thanks again.

Uh... You might want to skip ahead and go right to the new 7.3beta1.
Otherwise you are probably going to *want* to do another dump reload
cycle in the very near future.

Just a thought.

Jason

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Slow query when joining to un-analyzed temp table...
Следующее
От: Mario Weilguni
Дата:
Сообщение: Re: Date not being parsed as expected