Обсуждение: data Transfer rate priority on Postgres ?

Поиск
Список
Период
Сортировка

data Transfer rate priority on Postgres ?

От
"ngoncalves81@cantv.net"
Дата:
<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.

Re: data Transfer rate priority on Postgres ?

От
Neil Conway
Дата:
ngoncalves81@cantv.net wrote:
> Does Postgres have any kind of configuration that determines the
> speed of data transfer to the clients?

No.

> Is there any kind of connection priority?

No, although it is possible to crudely set priorities via OS-level tools
like nice(1).

-Neil