Foreign key creation on table with huge record count.

Поиск
Список
Период
Сортировка
От Gambhir Singh
Тема Foreign key creation on table with huge record count.
Дата
Msg-id CAHOGQfXR8JZk=-GyVeRVUNC4-ZoHUZmv=uRjWUOL2xnPuyDqnQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Foreign key creation on table with huge record count.  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: Foreign key creation on table with huge record count.  (Lucio Chiessi <lucio.chiessi@trustly.com>)
Re: Foreign key creation on table with huge record count.  (Ron <ronljohnsonjr@gmail.com>)
Re: Foreign key creation on table with huge record count.  (Abhishek Singh <abhi.singh.solanki@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi, 

I have a table with a record count of around 100 Million records. while creating foreign key on the table took a significant amount time to get created.

Is there any way to speed up the execution of creation of foreign key constraint ?

do we have parallel hint like option in postgreSQL as there in Oracle. 


--
Thanks & Regards
Gambhir Singh

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Problems with unique constraints
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Foreign key creation on table with huge record count.