From: | Rob Brown-Bayliss <r(dot)brown(dot)bayliss(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
Subject: | Re: Libpq is very slow on windows but fast on linux. |
Date: | 2010-11-08 04:59:06 |
Message-ID: | AANLkTinidMB-+E73f2VVNkXzca7RyYEjqkzvhwN+caPQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
No Joy. The tcp window stuff didn't make any difference. I tried
the unscientific speedtest.net to a server in Canada and all 3
machines (several times each)(. Linux, XP and Vista. The results are
all too close to call.
Yet psql or pgadmin are 4 or 5 times slower on the windows machines.
Dropping back to 8.3 made no difference. The XP machine is a fresh
install, it only has MS office and postgresql 8.3 installed, just to
test this.
I have come across many similar posts on the net, but there were
several years ago. Is any one else seeing similar results?
On Mon, Nov 8, 2010 at 3:19 PM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au> wrote:
> On 07/11/10 09:13, Rob Brown-Bayliss wrote:
>> Ok, So I did that, in the windows capture file are many many lines of
>> Red text on a black background, I assume thats a bad thing.
>
> If you examine the packet it'll say "invalid checksum". This will be
> because your network card is doing TCP checksum offloading, and you can
> almost certainly ignore the warning or turn it off. See:
>
> http://wiki.wireshark.org/TCP_Checksum_Verification
> http://www.wireshark.org/docs/wsug_html_chunked/ChAdvChecksums.html
>
>> As I said before I really don't know what I am looking at.
>
> Use the wireshark throughput graph for a starter. If you don't
> understand TCP/IP, wireshark probably won't help you much - but then, I
> learned about TCP/IP with wireshark. Consider doing the same - dive in,
> read about it, and have a play.
>
> I won't be too surprised if the issue turns out to be related to TCP
> window sizes and window scaling differences between the two machines.
>
> --
> Craig Ringer
>
> Tech-related writing: http://soapyfrogs.blogspot.com/
>
--
--
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Anders Söderman | 2010-11-08 05:16:14 | Re: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN) |
Previous Message | Craig Ringer | 2010-11-08 02:19:26 | Re: Libpq is very slow on windows but fast on linux. |