Re: Query performance

From: Tom Lane
Subject: Re: Query performance
Date: ,
Msg-id: 4475.1110568227@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Query performance  ("Lou O'Quin")
List: pgsql-performance

Tree view

Query performance  ("Lou O'Quin", )
 Re: Query performance  (Tom Lane, )
 Re: Query performance  ("Lou O'Quin", )
  Re: Query performance  (Tom Lane, )
 Re: Query performance  ("Lou O'Quin", )
 Re: Query performance  ("Steinar H. Gunderson", )
  Re: Query performance  (Antonio Batovanja, )
   Re: Query performance  (Christopher Kings-Lynne, )
 Re: Query performance  (Erwin Brandstetter, )
 Re: Query performance  (Erwin Brandstetter, )

"Lou O'Quin" <> 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


pgsql-performance by date:

From: Arshavir Grigorian
Date:
Subject: Re: Postgres on RAID5
From: Josh Berkus
Date:
Subject: Re: Postgres on RAID5