Postgres Pro
Downloads
Home   >   mailing lists

Speeding up adding fky on a very large table - Mailing list pgsql-general

From Ravi Krishna
Subject Speeding up adding fky on a very large table
Date
Msg-id 1365946824.316128.1666186309386@mail.yahoo.com
Whole thread Raw
Responses Re: Speeding up adding fky on a very large table
List pgsql-general
Tree view
AWS Aurora based on PG 13.


Large partitioned table of 5+ billion rows and 7TB in size.

ALTER TABLE abc ADD CONSTRAINT fk_123 FOREIGN KEY (a,b,c) REFERENCES xyz(1,2,3);

It seems this is not parallelized. Is there a way. Or directly going into each partition is the only way ( not even sure it is possible).


pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: How to store "blobs" efficiently for small and large sizes, with random access
Next
From: Dominique Devienne
Date:
Subject: Re: How to store "blobs" efficiently for small and large sizes, with random access