"Ed L." <pgsql@bluepolka.net> 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