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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Libpq is very slow on windows but fast on linux.
Дата
Msg-id 4CD75E2E.60405@postnewspapers.com.au
обсуждение исходный текст
Ответ на Re: Libpq is very slow on windows but fast on linux.  (Rob Brown-Bayliss <r.brown.bayliss@gmail.com>)
Ответы Re: Libpq is very slow on windows but fast on linux.  (Rob Brown-Bayliss <r.brown.bayliss@gmail.com>)
Список pgsql-general
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/

В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Finding rank of a single record
Следующее
От: Rob Brown-Bayliss
Дата:
Сообщение: Re: Libpq is very slow on windows but fast on linux.