Re: Need help identifying a periodic performance issue.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Need help identifying a periodic performance issue.
Дата
Msg-id 2736634.1637177330@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Need help identifying a periodic performance issue.  (Robert Creager <robertc@spectralogic.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Creager
Дата:
Сообщение: Re: Need help identifying a periodic performance issue.
Следующее
От: Robert Creager
Дата:
Сообщение: Re: Need help identifying a periodic performance issue.