Re: pg 8.1.2 performance issue

"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