Re: LONG delete with LOTS of FK's

From: Shaun Thomas <sthomas(at)optionshouse(dot)com>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: LONG delete with LOTS of FK's
Date: 2013-05-01 15:23:42
Message-ID: 5181337E.1050001@optionshouse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)optionshouse(dot)com

______________________________________________

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2013-05-01 15:31:08 Re: LONG delete with LOTS of FK's
Previous Message Larry Rosenman 2013-05-01 15:17:51 LONG delete with LOTS of FK's