Speeding up adding fky on a very large table

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Speeding up adding fky on a very large table
Дата
Msg-id 1365946824.316128.1666186309386@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Speeding up adding fky on a very large table  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Dominique Devienne
Дата:
Сообщение: Re: How to store "blobs" efficiently for small and large sizes, with random access
Следующее
От: Dominique Devienne
Дата:
Сообщение: Re: How to store "blobs" efficiently for small and large sizes, with random access