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