Re: Simple query takes a long time on win2K

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Simple query takes a long time on win2K
Дата
Msg-id 8594.1111601478@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Simple query takes a long time on win2K  ("A. Mous" <a.mous@shaw.ca>)
Список pgsql-general
"A. Mous" <a.mous@shaw.ca> writes:
> The confusing thing for me is that so far, the only consistent pattern here
> is that machines running win2k Pro take roughly 4 seconds to deliver the
> data to the client, while win XP machines perform much better (<200ms to
> deliver recordset).  I've tried installing QoS packet scheduler on win2K pro
> machines to no avail.

I really thought the QoS thing would be it.  Maybe there was some other
thing to do, configuration-wise, to make that do its thing properly?

If you could reproduce this behavior across the network I would tell you
to get out a packet analyzer (ethereal or some such) and sniff the
traffic to learn more.  Are there any programs that can sniff local TCP
traffic on win2k?

            regards, tom lane

PS: I've added pgsql-hackers-win32 to the cc list.

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

Предыдущее
От: "A. Mous"
Дата:
Сообщение: Re: Simple query takes a long time on win2K
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] contrib module intagg crashing the backend