Re: App very unresponsive while performing simple update - Mailing list pgsql-performance

From Tom Lane
Subject Re: App very unresponsive while performing simple update
Date
Msg-id 17733.1148832292@sss.pgh.pa.us
Whole thread Raw
In response to Re: App very unresponsive while performing simple update  (Greg Stark <gsstark@mit.edu>)
Responses Re: App very unresponsive while performing simple update  (Greg Stark <gsstark@mit.edu>)
Re: App very unresponsive while performing simple update  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> What queries are those two processes executing? And what foreign keys do you
> have on the product table or elsewhere referring to the product table? And
> what indexes do you have on those columns?

And what PG version is this?  Alvaro fixed the
foreign-keys-take-exclusive-locks problem in 8.1 ...

            regards, tom lane

pgsql-performance by date:

Previous
From: "Cstdenis"
Date:
Subject: Re: How can I make this query faster (resend)
Next
From: Greg Stark
Date:
Subject: Re: App very unresponsive while performing simple update