Re: Bad performance with cascaded deletes

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Bad performance with cascaded deletes
Дата
Msg-id 1528792786.2729.0.camel@cybertec.at
обсуждение исходный текст
Ответ на Bad performance with cascaded deletes  (Haug Bürger <haug.buerger@zalando.de>)
Список 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 по дате отправления:

Предыдущее
От: Steve Krenzel
Дата:
Сообщение: Re: Semantics around INSERT INTO with SELECT and ORDER BY.
Следующее
От: Ravi Krishna
Дата:
Сообщение: Re: Semantics around INSERT INTO with SELECT and ORDER BY.