Postgres Pro
Downloads
Home   >   mailing lists

Re: multiple threads inserting into the same table - Mailing list pgsql-performance

From Tom Lane
Subject Re: multiple threads inserting into the same table
Date
Msg-id 4511.1237849372@sss.pgh.pa.us
Whole thread Raw
In response to Re: multiple threads inserting into the same table  (Brian Cox <brian.cox@ca.com>)
List pgsql-performance
Tree view 
Brian Cox <brian.cox@ca.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: multiple threads inserting into the same table
Next
From: Sergey Burladyan
Date:
Subject: Why creating GIN table index is so slow than inserting data into empty table with the same index?