Postgres Pro
Downloads
Home   >   mailing lists

Re: slow delete - Mailing list pgsql-performance

From Jeff Janes
Subject Re: slow delete
Date
Msg-id CAMkU=1yt74r+DM3eHMq=EUUVc03GDgnH013OHLFSUigxSwobEQ@mail.gmail.com
Whole thread Raw
In response to slow delete  (Les <nagylzs@gmail.com>)
List pgsql-performance
Tree view

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 by date:

Previous
From: Les
Date:
Subject: Re: slow delete
Next
From: Martin Querleu
Date:
Subject: Question regarding writes when locking rows