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.
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. It seems to me that something is assigning the rate of
data transfer and giving it a priority within the net.
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?
We didnt have this problem with version 7.4 (Cygwin), al the PC had
a fast connection.
