Re: Adding foreign key performance

Поиск
Список
Период
Сортировка
От Jeff
Тема Re: Adding foreign key performance
Дата
Msg-id 20031028142524.30e9e6fc.threshar@torgo.978.org
обсуждение исходный текст
Ответ на Re: Adding foreign key performance  (Vivek Khera <khera@kcilink.com>)
Список pgsql-performance
On Tue, 28 Oct 2003 14:22:04 -0500
Vivek Khera <khera@kcilink.com> wrote:

> If you're restoring from a pg_dump -Fc (compressed dump) it already
> happens for you.  The indexes and foreign keys are not added until the
> very end, from what I recall.
>

This happens with regular dumps - at the end is a pile of alter table's
that create the indices, FK's and triggers.

Is the -Fc method different?

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Adding foreign key performance
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Adding foreign key performance