Re: Timing of 'SELECT 1'

Поиск
Список
Период
Сортировка
От Kurt Roeckx
Тема Re: Timing of 'SELECT 1'
Дата
Msg-id 20040310194754.GA10352@ping.be
обсуждение исходный текст
Ответ на Re: Timing of 'SELECT 1'  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Timing of 'SELECT 1'  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Mar 10, 2004 at 11:42:12AM -0500, Bruce Momjian wrote:
> 
> I am using log_duration, so this isn't measuring network time, just time
> in the backend (at least I think so).

I don't think it is.

If I do a query on localhost with lots of data, I get a small
time in the log, if I do it over a slow link the time get higher.
It changes from 1 second to 2 minutes or something.

So I think it's until the client has received the data.


Kurt



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Shouldn't B'1' = 1::bit be true?
Следующее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: PITR Functional Design v2 for 7.5