Brian Cox <brian(dot)cox(at)ca(dot)com> writes:> This is a java app. A thread dump reveals that these 5 threads are all> asleep on a socket read to postgres (see below).
It seems clear that what you've got isn't a performance problem.May I suggest taking it to pgsql-jdbc? The folk there are more likelyto be able to help you figure out what's wrong than most of us.
regards, tom lane