Home > mailing lists

Foreign key creation on table with huge record count. - Mailing list pgsql-admin

From	Gambhir Singh
Subject	Foreign key creation on table with huge record count.
Date	January 30, 2023 23:12:45
Msg-id	CAHOGQfXR8JZk=-GyVeRVUNC4-ZoHUZmv=uRjWUOL2xnPuyDqnQ@mail.gmail.com Whole thread Raw
Responses	Re: Foreign key creation on table with huge record count. Re: Foreign key creation on table with huge record count. Re: Foreign key creation on table with huge record count. Re: Foreign key creation on table with huge record count.
List	pgsql-admin

Tree view

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 by date:

From: Laurenz Albe
Date: 26 January 2023, 23:44:35
Subject: Re: Problems with unique constraints

From: Scott Ribe
Date: 31 January 2023, 00:09:35
Subject: Re: Foreign key creation on table with huge record count.

Foreign key creation on table with huge record count. - Mailing list pgsql-admin

Previous

Next