Re: Bad performance with cascaded deletes - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Bad performance with cascaded deletes
Date
Msg-id 1528792786.2729.0.camel@cybertec.at
Whole thread Raw
In response to Bad performance with cascaded deletes  (Haug Bürger <haug.buerger@zalando.de>)
List pgsql-general
Haug Bürger wrote:
> Delete on zpg_data.session  (cost=190.51..4491.20 rows=500 width=46)
> ...
> Planning time: 0.222 ms
>  Trigger RI_ConstraintTrigger_a_16481 for constraint
> availability_cache_ac_session_id_fkey: time=350.116 calls=500
> 
> For me this reads like the delete takes 0.2ms and the cascaded delete
> takes 350ms.

Could you share the complete plan?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com


pgsql-general by date:

Previous
From: Steve Krenzel
Date:
Subject: Re: Semantics around INSERT INTO with SELECT and ORDER BY.
Next
From: Ravi Krishna
Date:
Subject: Re: Semantics around INSERT INTO with SELECT and ORDER BY.