Re: slow delete - Mailing list pgsql-performance

From PFC
Subject Re: slow delete
Date
Msg-id op.udrik3eocigqcu@apollo13.peufeu.com
Whole thread Raw
In response to slow delete  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-performance
> by the way, there is a foreign key on another table that references the
> primary key col0 on table test.

    Is there an index on the referencing field in the other table ? Postgres
must find the rows referencing the deleted rows, so if you forget to index
the referencing column, this can take forever.

pgsql-performance by date:

Previous
From: Russell Smith
Date:
Subject: Re: Define all IP's in the world in pg_hba.conf
Next
From: Jessica Richard
Date:
Subject: Re: slow delete