Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd query behavior [urgent, but long] - Mailing list pgsql-admin

From Tom Lane
Subject Re: Odd query behavior [urgent, but long]
Date
Msg-id 2190.1093461392@sss.pgh.pa.us
Whole thread Raw
In response to Odd query behavior [urgent, but long]  (Steve Lane <slane@soliantconsulting.com>)
Responses Re: Odd query behavior [urgent, but long]  (Steve Lane <slane@soliantconsulting.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Steve Lane
Date:
Subject: Odd query behavior [urgent, but long]
Next
From: Steve Lane
Date:
Subject: Re: Odd query behavior [urgent, but long]