Re: multiple threads inserting into the same table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: multiple threads inserting into the same table
Дата
Msg-id 4511.1237849372@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: multiple threads inserting into the same table  (Brian Cox <brian.cox@ca.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: multiple threads inserting into the same table
Следующее
От: Sergey Burladyan
Дата:
Сообщение: Why creating GIN table index is so slow than inserting data into empty table with the same index?