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 1281.1237838309@sss.pgh.pa.us
Whole thread Raw
In response to 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:
> 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:

Previous
From: Anne Rosset
Date:
Subject: Re: Need help with one query
Next
From: Brian Cox
Date:
Subject: Re: multiple threads inserting into the same table