Re: Deletes and large tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Deletes and large tables
Date
Msg-id 23013.1118419678@sss.pgh.pa.us
Whole thread Raw
In response to Re: Deletes and large tables  (Edmund Dengler <edmundd@eSentire.com>)
List 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 by date:

Previous
From: David Siebert
Date:
Subject: 8.0 Install issues
Next
From: Edmund Dengler
Date:
Subject: Re: Deletes and large tables