Search Postgresql Archives

Re: Libpq is very slow on windows but fast on linux.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Nov 7, 2010 at 1:06 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
> when you say 500mS, thats the round trip ping time?

It's a bit less, for example SELECT max(id) on the same table takes
about 350ms.  Yes, I am in New Zealand, the server is in Canada. pings
take about 275ms average.

> I think I'd run a packet sniffer like Wireshark on both client platforms,
> sniffing 5432/tcp and see if there's something unusual in the timing of the
> packets, incorrect MTU or something, lost packets and extra retries, or
> whatever.   Perhaps Windows isn't using a sufficiently large TCP Recieve
> Window (RWIN) value, or something.

I am a bit out of my depth there, but for all other network use the
machine seems the same in either os.  That is no noticiable difference
in download/upload speed.



--

Rob

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux