> > I've done the tests with rc1. This is still as slow on windows ...
> about
> > 6-10
> > times slower thant linux (via Ip socket). (depending on 
> using prepared 
> > queries, etc...)
> > 
> > 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 ?
> [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 :)]
> Just to recap Marc and I have been looking at the performance 
> disparity between windows and linux for a single transaction 
> statement by statement insert on a very narrow table with no 
> keys from a remote client.  Marc's observations showed (and I 
> verified) that windows is much slower in this case than it 
> should be.  I gprof'ed both the psql client and the server 
> during the insert and didn't see anything seriously out of 
> order...unfortunately QQ's latest win32 performance tweaks 
> haven't helped.
> Marc's observation that by switching to a linux client drops 
> time down drastically is really intersing!

Could this be a case of the network being slow, as we've seen a couple
of times before? And if you run psql on the local box, you get it

Do you get a speed difference between the local windows box and a remote
wnidows box?


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to