From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, "Marc Cousin" <mcousin(at)sigma(dot)fr> |
Cc: | <pgsql-performance(at)postgresql(dot)org>, "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
Subject: | Re: insert performance for win32 |
Date: | 2005-11-02 13:54:14 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE6C7B4A@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> > 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
double.
Do you get a speed difference between the local windows box and a remote
wnidows box?
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-02 14:41:14 | Re: 8.1beta3 performance |
Previous Message | Merlin Moncure | 2005-11-02 13:45:02 | Re: improvise callbacks in plpgsql |