Tom Allison <[EMAIL PROTECTED]> writes:
> I have ~250K rows in this table.
> the token_idx is referenced in two other tables, both of whom have a
> foreign key constraint to ON DELETE CASCADE.
> Of the other two tables, one has ~1M rows and the other ~350K rows.
> Problem:
> Deleting one row can take 2 seconds.
> Is there something I can do to improve the speed.
Put indexes on the referencing columns. Without that, a seqscan is
required to look for referencing rows.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
