writes: > it appears to actually be hypersensitive to the transport delay. The =3D > ratios of time for the data transport (assuming 1 for the local server) = =3D > are: > 1 : 2.43 : 7.71 > whereas the query execution time ratios are: > 1 : 2.08 : 25.5 (!!!) How do you know that's what the data transport time is --- ie, how can you measure that separately from the total query time? regards, tom lane --=__Part50732EB8.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML

Hi Tom. I referenced the status line of pgAdmin. Per = the pgAdmin help file:

"The status line will show how long the last query took to complete. = If a dataset was returned, not only the elapsed time for server execution = is displayed, but also the time to retrieve the data from the server to = the Data Output page."

Lou

>>> Tom Lane <tgl@sss.pgh.pa.us> 3/11/2005 = 12:10 PM >>>

"Lou O'Quin" <loquin@talleyds.com> = writes:
> it appears to actually be hypersensitive to the transport = delay. The =3D
> ratios of time for the data transport (assuming 1 = for the local server) =3D
> are:
> 1 : 2.43 : 7.71

> = whereas the query execution time ratios are:
> 1 : 2.08 : 25.5 = (!!!)

How do you know that's what the data transport time is --- = ie, how can
you measure that separately from the total query time?
regards, tom = lane

--=__Part50732EB8.0__=--