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

Re: [PERFORM] insert performance for win32

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Marc Cousin" <mcousin(at)sigma(dot)fr>
Cc: <pgsql-performance(at)postgresql(dot)org>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: [PERFORM] insert performance for win32
Date: 2005-09-07 13:08:18
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD290@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-performance
> On Tuesday 06 September 2005 19:11, Merlin Moncure wrote:
> 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

ok, I've been in crunching profile profile graphs, and so far have been
only been able to draw following conclusions.

For bulk, 'in-transaction' insert:
1. win32 is slower than linux.  win32 time for each insert grows with #
inserts in xact, linux does not (or grows much slower).  Win32 starts
out about 3x slower and grows to 10x slower after 250k inserts.

2. ran a 50k profile vs. 250k profile.  Nothing jumps out as being
slower or faster: most time is spent in yyparse on either side.  From
this my preliminary conclusion is that there is something going on in
the win32 api which is not showing in the profile.

3. The mingw gprof cumulative seconds does not show measurable growth in
cpu time/insert in 50k/250k profile.

I'm now talking suggestions about where to look for performance problems
:(.
Merlin

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2005-09-07 15:02:13
Subject: Re: [PERFORM] insert performance for win32
Previous:From: Merlin MoncureDate: 2005-09-07 12:04:15
Subject: Re: insert performance for win32

pgsql-hackers-win32 by date

Next:From: Tom LaneDate: 2005-09-07 15:02:13
Subject: Re: [PERFORM] insert performance for win32
Previous:From: Merlin MoncureDate: 2005-08-26 15:08:06
Subject: Re: profiling on win32

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