Re: lock problem

Rural Hunter  wrote:

> I'm seeing connection hang issue these days. many concurrent
> connections are hanging on db. They basically do the same thing:
> update different rows in same table. The sql itself should run very
> fast as it's updating just one row based on an unique key.

> update article set tm_update=$

I don't see a WHERE clause, so it looks like you're updating the
whole table each time.  Once a row is updated by one of the
transactions, others will block on attempts to update the same row
until the first transaction commits.

-Kevin