Re: Query performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query performance
Дата
Msg-id 4475.1110568227@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query performance  ("Lou O'Quin" <loquin@talleyds.com>)
Список pgsql-performance
"Lou O'Quin" <loquin@talleyds.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Lou O'Quin"
Дата:
Сообщение: Query performance
Следующее
От: "Lou O'Quin"
Дата:
Сообщение: Re: Query performance