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

From David Wilson
Subject Re: multiple threads inserting into the same table
Date
Msg-id [email protected]
Whole thread Raw
In response to multiple threads inserting into the same table  (Brian Cox <[email protected]>)
List pgsql-performance
On Mon, Mar 23, 2009 at 3:34 PM, Brian Cox <[email protected]> wrote:
> The application log shows that 99652 rows are being inserted into relation
> ts_stats_transet_user_daily. 5 threads are doing the inserts. The schema is
> lengthy, but it has a synthetic primary key (ts_id int8 not null) and the
> following constraints:

How many indexes are there on ts_stats_transset_user_daily?

Are these rows being inserted in individual insert statements, or are
they batched in some fashion?

What's the disk/cpu activity on your system look like?

--
- David T. Wilson
[email protected]

pgsql-performance by date:

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