Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: App very unresponsive while performing simple update
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Greg Stark <gsstark(at)mit(dot)edu>
- Cc: Brendan Duddridge <brendan(at)clickspace(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: App very unresponsive while performing simple update
- Date: Sun, 28 May 2006 12:04:52 -0400
Greg Stark <gsstark(at)mit(dot)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
- Follow-Ups:
- Re: App very unresponsive while performing simple update
- From: Brendan Duddridge
- Re: App very unresponsive while performing simple update
- From: Greg Stark
- Re: App very unresponsive while performing simple update
- References:
- App very unresponsive while performing simple update
- From: Brendan Duddridge
- Re: App very unresponsive while performing simple update
- From: Brendan Duddridge
- Re: App very unresponsive while performing simple update
- From: Greg Stark
- App very unresponsive while performing simple update
- Prev by Date: Re: How can I make this query faster (resend)
- Next by Date: Re: App very unresponsive while performing simple update
- Previous by thread: Re: App very unresponsive while performing simple update
- Next by thread: Re: App very unresponsive while performing simple update
- Indexes: