Re: microsecond log timestamps

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: microsecond log timestamps
Дата
Msg-id 10377.989690744@sss.pgh.pa.us
обсуждение исходный текст
Ответ на microsecond log timestamps  (Ed Loehr <eloehr@austin.rr.com>)
Список pgsql-general
Ed Loehr <eloehr@austin.rr.com> writes:
> Someone probably had a good reason for doing this, but looking at
> backend/utils/error/elog.c line 592 in 7.1, it looks like the pre-7.1
> capability for microsecond timestamp granularity (e.g.,
> 20010511.14:23:49.325) in tprintf_timestamp() was removed in favor of a
> coarser 1-second resolution using time_t in print_timestamp()?  Is that
> correct?  If not, what am I missing?

> If so, is anyone aware of an existing patch to give sub-second log
> timestamp capability?  Microsecond granularity has been very helpful for
> query timing.

I can't see any good reason that print_timestamp() shouldn't use
gettimeofday() rather than time(); certainly there's no portability
argument for it, because we use gettimeofday in several other places.

Feel free to submit a patch...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: about new join syntax performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: COPY locking