Re: Deletes and large tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Deletes and large tables
Дата
Msg-id 23013.1118419678@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Deletes and large tables  (Edmund Dengler <edmundd@eSentire.com>)
Список pgsql-general
Edmund Dengler <edmundd@eSentire.com> writes:
> This table has 3 foreign keys, but that should not matter during deletes.

Richard was inquiring about foreign keys linking *into* this table, not
out of it.

In particular, foreign keys that don't have indexes on the referencing
columns; those will incur seqscans to check for appearances of the value
you are deleting.

            regards, tom lane

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

Предыдущее
От: David Siebert
Дата:
Сообщение: 8.0 Install issues
Следующее
От: Edmund Dengler
Дата:
Сообщение: Re: Deletes and large tables