Re: Need help identifying a periodic performance issue. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Need help identifying a periodic performance issue.
Date
Msg-id 2736634.1637177330@sss.pgh.pa.us
Whole thread Raw
In response to Need help identifying a periodic performance issue.  (Robert Creager <robertc@spectralogic.com>)
List pgsql-performance
Justin Pryzby <pryzby@telsasoft.com> writes:
> It shows that the process is running FK triggers.

Indeed, and doing a seqscan therein.  Normally I'd suppose that
this reflects a lack of an index, but RI_FKey_check should always
be doing something that matches the referenced table's unique
constraint, so why isn't it using that?

            regards, tom lane



pgsql-performance by date:

Previous
From: Robert Creager
Date:
Subject: Re: Need help identifying a periodic performance issue.
Next
From: Robert Creager
Date:
Subject: Re: Need help identifying a periodic performance issue.