Re: WARNING: foreign key constraint will require costly sequential scans during pg_restore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WARNING: foreign key constraint will require costly sequential scans during pg_restore
Дата
Msg-id 11982.1140622237@sss.pgh.pa.us
обсуждение исходный текст
Ответ на WARNING: foreign key constraint will require costly sequential scans during pg_restore  (CG <cgg007@yahoo.com>)
Список pgsql-admin
Дерево обсуждения 
CG <cgg007@yahoo.com> writes:
> pg_restore: WARNING:  foreign key constraint "luuid_fkey" will require costly
> sequential scans
> DETAIL:  Key columns "luuid" and "luuid" are of different types:
> public.uniqueidentifier and public.uniqueidentifier.

That seems a bit odd.  Would you provide a test case?

            regards, tom lane

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

Предыдущее
От: CG
Дата:
Сообщение: WARNING: foreign key constraint will require costly sequential scans during pg_restore
Следующее
От: Andy Shellam
Дата:
Сообщение: WAL recovery