Re: pg 7.4.x - pg_restore impossibly slow

Поиск
Список
Период
Сортировка
От patrick keshishian
Тема Re: pg 7.4.x - pg_restore impossibly slow
Дата
Msg-id 53b425b00604140010v718aa171p19d9253ce58d0006@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg 7.4.x - pg_restore impossibly slow  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
On 4/13/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> On Thu, Apr 13, 2006 at 06:26:00PM -0700, patrick keshishian wrote:
> > $ dropdb dbname
> > $ createdb dbname
> > $ pg_restore -vsOd dbname dbname.DUMP
>
> That step is pointless, because the next pg_restore will create the
> schema for you anyway.

Yes, I noticed this with the verbose output (random
non-standard option "-v").

I was providing all information (read: exact steps taken)
which may have been relevant to my post/question, so
that, I would avoid being guilty of omitting any possibly
significant, yet random information.

Thanks for the insight,
--patrick

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

Предыдущее
От: "patrick keshishian"
Дата:
Сообщение: Re: pg 7.4.x - pg_restore impossibly slow
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: Inserts optimization?