From: Qingqing Zhou <zhouqq@cs.toronto.edu>
To: Merlin Moncure <merlin.moncure@rcsonline.com>
Cc: Marc Cousin <mcousin@sigma.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: insert performance for win32
Date: Thu, 3 Nov 2005 02:11:43 -0500 (EST)
Message-ID: <Pine.LNX.4.58.0511030153490.9091@eon.cs> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD76C@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD76C@Herge.rcsinc.local>
On Wed, 2 Nov 2005, Merlin Moncure wrote:
> >
> > By the way, we've tried to insert into the windows database from a
> > linux psql client, via the network. In this configuration, inserting
> > is only about 2 times slower than inserting locally (the linux client
> > had a slower CPU 1700Mhz agains 3000). Could it be related to a
> > problem in the windows psql client ?
> >
If you put client/server on the same machine, then we don't know how the
CPU is splitted. Can you take a look at the approximate number by
observing the task manager data while running?
If communication code is the suspect, can we measure the difference if we
disable the redefinition of recv()/send() etc in port/win32.h (may require
change related code a little bit as well). In this way, the socket will
not be able to pickup signals, but let see if there is any performance
difference first.
Regards,
Qingqing
>
> [OK, I'm bringing this back on-list, and bringing it to QingQing's
> attention, who I secretly hope is the right person to be looking at this
> problem :)]
>
P.s. You scared me ;-)
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: zhouqq@cs.toronto.edu, merlin.moncure@rcsonline.com, mcousin@sigma.fr
Subject: Re: insert performance for win32
In-Reply-To: <Pine.LNX.4.58.0511030153490.9091@eon.cs>
* 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