Re: Timing of 'SELECT 1'

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Timing of 'SELECT 1'
Дата
Msg-id 9258.1078949090@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Timing of 'SELECT 1'  (Kurt Roeckx <Q@ping.be>)
Список pgsql-hackers
Kurt Roeckx <Q@ping.be> writes:
> 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.

It'll at least be until the backend has been able to send the data.
However, for a small amount of retrieved data, I doubt the kernel
will make the backend wait at the send() --- if there even is one
before the log entry is made.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: selective statement logging
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Timing of 'SELECT 1'