Re: Decrease time needed to CREATE INDEX and FOREIGN KEY on new tablecolumn which has all values NULL - Mailing list pgsql-general

> The table is huge and it takes a lot of time to add the INDEX and the FOREIGN KEY although all values are NULL.
> Considering that the new DepartmentId column is NULL for all rows at this point, is there a way to make the INDEX and
FOREIGNKEY creation run faster? 

In your script to create index add this:

set maintenance_work_mem = '1GB'
or any other figure you feel comfortable.