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
In response to
pgsql-performance by date
|Next:||From: Anne Rosset||Date: 2009-03-23 19:56:11|
|Subject: Re: Need help with one query|
|Previous:||From: Brian Cox||Date: 2009-03-23 19:34:03|
|Subject: multiple threads inserting into the same table|