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