data Transfer rate priority on Postgres ?

From: "ngoncalves81(at)cantv(dot)net" <ngoncalves81(at)cantv(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: data Transfer rate priority on Postgres ?
Date: 2005-09-08 20:23:44
Message-ID: 58910-22005948202344851@cantv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 35.4pt"><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" /><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"><SPAN style="mso-tab-count:
1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</SPAN>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">&nbsp; </SPAN>It seems to me that something is assigning the rate of
data transfer and giving it a priority within the net.<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"><SPAN style="mso-tab-count:
1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</SPAN>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?<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY:
Arial; mso-ansi-language: EN-US"><SPAN style="mso-tab-count:
1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</SPAN>We didn’t have this problem with version 7.4 (Cygwin), al the PC had
a “fast” connection.<o:p></o:p></SPAN></P>

Attachment Content-Type Size
unknown_filename text/html 2.3 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-09-08 20:36:16 Re: per user logging
Previous Message Richard Huxton 2005-09-08 20:08:08 Re: per user logging