Skip site navigation (1) Skip section navigation (2)

Re: multiple threads inserting into the same table

From: David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com>
To: Brian Cox <brian(dot)cox(at)ca(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: multiple threads inserting into the same table
Date: 2009-03-23 19:49:34
Message-ID: e7f9235d0903231249x3dc20111yb1e280c28abf761a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Anne RossetDate: 2009-03-23 19:56:11
Subject: Re: Need help with one query
Previous:From: Brian CoxDate: 2009-03-23 19:34:03
Subject: multiple threads inserting into the same table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group