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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
