From: Marc Cousin <mcousin@sigma.fr>
To: pgsql-performance@postgresql.org
Cc: Merlin Moncure <merlin.moncure@rcsonline.com>
Subject: Re: insert performance for win32
Date: Wed, 7 Sep 2005 14:02:02 +0200
Message-ID: <200509071402.02402.mcousin@sigma.fr> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD281@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD281@Herge.rcsinc.local>
On Tuesday 06 September 2005 19:11, Merlin Moncure wrote:
> > This makes me wonder if we are looking in the wrong place. Maybe the
> > problem is coming from psql? More results to follow.
>
> problem is not coming from psql.
>
> One thing I did notice that in a 250k insert transaction the insert time
> grows with #recs inserted. Time to insert first 50k recs is about 27
> sec and last 50 k recs is 77 sec. I also confimed that size of table is
> not playing a role here.
>
> Marc, can you do select timeofday() every 50k recs from linux? Also a
> gprof trace from linux would be helpful.
>
Here's the timeofday ... i'll do the gprof as soon as I can.
Every 50000 rows...
Wed Sep 07 13:58:13.860378 2005 CEST
Wed Sep 07 13:58:20.926983 2005 CEST
Wed Sep 07 13:58:27.928385 2005 CEST
Wed Sep 07 13:58:35.472813 2005 CEST
Wed Sep 07 13:58:42.825709 2005 CEST
Wed Sep 07 13:58:50.789486 2005 CEST
Wed Sep 07 13:58:57.553869 2005 CEST
Wed Sep 07 13:59:04.298136 2005 CEST
Wed Sep 07 13:59:11.066059 2005 CEST
Wed Sep 07 13:59:19.368694 2005 CEST
> Merlin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mcousin@sigma.fr, merlin.moncure@rcsonline.com
Subject: Re: insert performance for win32
In-Reply-To: <200509071402.02402.mcousin@sigma.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox