Re: Odd query behavior [urgent, but long]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Lane <slane(at)soliantconsulting(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, Jamie Thomas <jthomas(at)soliantconsulting(dot)com>
Subject: Re: Odd query behavior [urgent, but long]
Date: 2004-08-25 19:16:32
Message-ID: 2190.1093461392@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Steve Lane <slane(at)soliantconsulting(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Lane 2004-08-25 19:26:52 Re: Odd query behavior [urgent, but long]
Previous Message kris pal 2004-08-25 18:53:34 regression database