Re: slow delete

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: slow delete
Дата
Msg-id CAMkU=1yt74r+DM3eHMq=EUUVc03GDgnH013OHLFSUigxSwobEQ@mail.gmail.com
обсуждение исходный текст
Ответ на slow delete  (Les <nagylzs@gmail.com>)
Список pgsql-performance
Дерево обсуждения

On Tue, Aug 15, 2023 at 4:23 PM Les <nagylzs@gmail.com> wrote:

{

"Trigger Name": "RI_ConstraintTrigger_a_75463",

"Constraint Name": "fk_pfq_src_product_file",

"Relation": "product_file",

"Time": 11179.429,

"Calls": 90

},

...
 
The one with fk_pfft_product looks like this, it has about 5000 records in it:

That constraint took essentially no time.  You need to look into the one that took all of the time, 
which is fk_pfq_src_product_file.
 
Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Les
Дата:
Сообщение: Re: slow delete
Следующее
От: Martin Querleu
Дата:
Сообщение: Question regarding writes when locking rows