Postgres Professional
   

Re: multiple threads inserting into the same table

From: Tom Lane
Subject: Re: multiple threads inserting into the same table
Date: ,
Msg-id: 4511.1237849372@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: multiple threads inserting into the same table  (Brian Cox)
List: pgsql-performance

Tree view

multiple threads inserting into the same table  (Brian Cox, )
 Re: multiple threads inserting into the same table  (David Wilson, )
 Re: multiple threads inserting into the same table  (Tom Lane, )
 Re: multiple threads inserting into the same table  (Brian Cox, )
  Re: multiple threads inserting into the same table  (Scott Marlowe, )
   Re: multiple threads inserting into the same table  (Tom Lane, )
  Re: multiple threads inserting into the same table  (Tom Lane, )
 Re: multiple threads inserting into the same table  (Brian Cox, )
 Re: multiple threads inserting into the same table  (Brian Cox, ) 
Brian Cox <> 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

pgsql-performance by date:

Previous:
From: Tom Lane
Date:
Subject: Re: Why creating GIN table index is so slow than inserting data into empty table with the same index?
Next:
From: Kouber Saparev
Date:
Subject: Re: LIMIT confuses the planner