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 ?
|
Список | 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 PCs 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 PCs and 20 to 30 seconds in other PCs (at the same time). This creates a situation where the program runs faster in some PCs 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 didnt have this problem with version 7.4 (Cygwin), al the PC had a fast connection.
В списке pgsql-general по дате отправления: