Re: Query performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lou O'Quin" <loquin(at)talleyds(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2005-03-11 19:10:27
Message-ID: 4475.1110568227@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Lou O'Quin" <loquin(at)talleyds(dot)com> writes:
> it appears to actually be hypersensitive to the transport delay. The =
> ratios of time for the data transport (assuming 1 for the local server) =
> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Lou O'Quin 2005-03-11 19:38:16 Re: Query performance
Previous Message jelle 2005-03-11 18:54:30 Questions about 2 databases.