Re: LONG delete with LOTS of FK's

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Re: LONG delete with LOTS of FK's
Дата
Msg-id 5181337E.1050001@optionshouse.com
обсуждение исходный текст
Ответ на LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Ответы Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Список pgsql-general
On 05/01/2013 10:17 AM, Larry Rosenman wrote:

> I have an app that we have a number of tables that all have FK
> relationships with the account table.

OK so far.

> Referenced by:
>      * Redacted one-billion foreign keys

Wow. I really hope every single one of those tables has an index on the
listed column, and it's the same datatype (bigint). Otherwise, this is
going to take a long, long time.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: LONG delete with LOTS of FK's
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: LONG delete with LOTS of FK's