Re: Need help identifying a periodic performance issue.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Robert Creager <robertc(at)spectralogic(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Need help identifying a periodic performance issue.
Date: 2021-11-17 19:28:50
Message-ID: 2736634.1637177330@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Justin Pryzby <pryzby(at)telsasoft(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Creager 2021-11-17 19:51:49 Re: Need help identifying a periodic performance issue.
Previous Message Justin Pryzby 2021-11-17 19:00:38 Re: Need help identifying a periodic performance issue.