Re: slow delete - Mailing list pgsql-performance

From Tom Lane
Subject Re: slow delete
Date
Msg-id 1174734.1692131859@sss.pgh.pa.us
Whole thread Raw
In response to slow delete  (Les <nagylzs@gmail.com>)
Responses Re: slow delete  (Les <nagylzs@gmail.com>)
List pgsql-performance
Les <nagylzs@gmail.com> writes:
> It seems that two foreign key constraints use 10.395 seconds out of the
> total 11.24 seconds. But I don't see why it takes that much?

Probably because you don't have an index on the referencing column.
You can get away with that, if you don't care about the speed of
deletes from the PK table ...

            regards, tom lane



pgsql-performance by date:

Previous
From: Les
Date:
Subject: slow delete
Next
From: Les
Date:
Subject: Re: slow delete