Re: multiple threads inserting into the same table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Cox <brian(dot)cox(at)ca(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: multiple threads inserting into the same table
Date: 2009-03-23 23:02:52
Message-ID: 4511.1237849372@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 likely
to be able to help you figure out what's wrong than most of us.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sergey Burladyan 2009-03-24 00:59:34 Why creating GIN table index is so slow than inserting data into empty table with the same index?
Previous Message Tom Lane 2009-03-23 22:57:34 Re: multiple threads inserting into the same table