Re: Odd query behavior [urgent, but long]

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd query behavior [urgent, but long]
Дата
Msg-id 2190.1093461392@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Odd query behavior [urgent, but long]  (Steve Lane <slane@soliantconsulting.com>)
Ответы Re: Odd query behavior [urgent, but long]  (Steve Lane <slane@soliantconsulting.com>)
Список pgsql-admin
Steve Lane <slane@soliantconsulting.com> writes:
> I have enabled pretty extensive query logging on the 7.1.3 instance. What I
> see is that certain queries take hideously long.

Tell us about foreign keys associated with the table being updated?
An UPDATE would fire triggers for both referencing and referenced keys ...

I'm suspecting an unindexed or datatype-incompatible foreign key column.

            regards, tom lane

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

Предыдущее
От: Steve Lane
Дата:
Сообщение: Odd query behavior [urgent, but long]
Следующее
От: Steve Lane
Дата:
Сообщение: Re: Odd query behavior [urgent, but long]