Re: multiple threads inserting into the same table

On Mon, Mar 23, 2009 at 3:34 PM, Brian Cox <brian(dot)cox(at)ca(dot)com> 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
david(dot)t(dot)wilson(at)gmail(dot)com