Re: Confused by 'timing' results

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Confused by 'timing' results
Дата
Msg-id 25773.1283446146@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Confused by 'timing' results  (A J <s5aly@yahoo.com>)
Список pgsql-admin
A J <s5aly@yahoo.com> writes:
> The problem I am now facing in using log_min_duration_statement is that all the
> clients have to write to a single log file in the pg_log directory. So they have
> to wait for the other writes to happen before completing their write. This seems
> to be reason why the measured duration in the log file (for several concurrent
> clients) is way more, infact much more than what was measured by psql timing
> from the client side.

Do you have any actual evidence for that being the problem, as opposed
to some other effect?  Because I don't recall anybody else complaining
about this.

Personally I'd wonder for example about whether the server has a really
slow gettimeofday()...

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Confused by 'timing' results
Следующее
От: Kong Mansatiansin
Дата:
Сообщение: Re: Query Optimization with Partitioned Tables