data Transfer rate priority on Postgres ?

Поиск
Список
Период
Сортировка
От ngoncalves81@cantv.net
Тема data Transfer rate priority on Postgres ?
Дата
Msg-id 58910-22005948202344851@cantv.net
обсуждение исходный текст
Ответы Re: data Transfer rate priority on Postgres ?  (Neil Conway <neilc@samurai.com>)
Список pgsql-general
<SPAN
style="FONT-FAMILY: Arial; mso-ansi-language: EN-US">I just installed
Postgres 8.0 (Windows native) on a HP server with Windows 2000 Server
Service Pack 4. This database is accessed by several windows PC’s with an
ODBC (ver. 7.03.02.00) through a 100Mbps intranet. <?xml:namespace prefix =
o ns = "urn:schemas-microsoft-com:office:office" />
<SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"><SPAN style="mso-tab-count:
1">           
I have notice that when I run a program that requires about 2 MB of
information from the server to the PC, it takes about 2-3 seconds to load
the information in some PC’s and 20 to 30 seconds in other PC’s (at the
same time). This creates a situation where the program runs “faster” in
some PC’s than in others. But this situation is not hardware related
because one day a PC might have a “fast” connection and the next day the
same PC it will have a “slow” connection. Also if I swap a PC that has a
“fast” connection in the net point of another with a “slow” connection,
both PC´s will keep their rate of data transfer.<SPAN style="mso-spacerun:
yes">  It seems to me that something is assigning the rate of
data transfer and giving it a priority within the net.
<SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"><SPAN style="mso-tab-count:
1">           
Does Postgres have any kind of configuration that determines the
speed of data transfer to the clients? Is there any kind of connection
priority? Or, this is a Windows configuration problem?
<SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"> 
<SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"><SPAN style="mso-tab-count:
1">           
We didn’t have this problem with version 7.4 (Cygwin), al the PC had
a “fast” connection.

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: per user logging
Следующее
От: Tom Lane
Дата:
Сообщение: Re: per user logging