"Ed L." <pgsql@xxxxxxxxxxxxx> writes: > I see what appear to be many single transactions holding > RowExclusiveLocks for sometimes 40-50 seconds while their query > shows "<IDLE> in transaction". > ... > I'm thinking that means the client is simply tweaking a row and > then failing to commit the change for 40-50 seconds. Is that > consistent? That's what it sounds like to me. You might consider logging all commands from these clients for awhile so you can check that theory. regards, tom lane
