Re: multiple threads inserting into the same table

From: Tom Lane
Subject: Re: multiple threads inserting into the same table
Date: ,
Msg-id: 1281.1237838309@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: 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:
> The application log shows that 99652 rows are being inserted into
> relation ts_stats_transet_user_daily. 5 threads are doing the inserts.

pg_stat_activity says those five threads are doing nothing except
sitting around with open transactions.  You sure you don't have a bug on
the application side?

            regards, tom lane


pgsql-performance by date:

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