Re: 9.5 release notes

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: 9.5 release notes
Дата
Msg-id CAKJS1f9LQ_AT7XFwt3JXgx0iquo=_nt2J=pEir_MZ9Yo2aJ8fg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 9.5 release notes  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: 9.5 release notes
Список pgsql-hackers

On 7 August 2015 at 14:24, Bruce Momjian <bruce@momjian.us> wrote:
On Tue, Jun 30, 2015 at 09:00:44PM +0200, Andres Freund wrote:
> * 2014-12-08 [519b075] Simon ..: Use GetSystemTimeAsFileTime directly in win32
>   2014-12-08 [8001fe6] Simon ..: Windows: use GetSystemTimePreciseAsFileTime if ..
>   Timer resolution isn't a unimportant thing for people using explain?

This all seemed very internals-only, e.g.:

    On most Windows systems this change will actually have no significant effect on
    timestamp resolution as the system timer tick is typically between 1ms and 15ms
    depending on what timer resolution currently running applications have
    requested. You can check this with clockres.exe from sysinternals. Despite the
    platform limiation this change still permits capture of finer timestamps where
    the system is capable of producing them and it gets rid of an unnecessary
    syscall.

Was I wrong?


This does have a user visible change. Timestamps are now likely to have 6 digits after the decimal point, if they're on a version of windows which supports GetSystemTimePreciseAsFileTime();

Master:

postgres=# select now();
              now
-------------------------------
 2015-08-09 01:14:01.959645+12
(1 row)

9.4.4
postgres=# select now();
            now
----------------------------
 2015-08-09 01:15:09.783+12
(1 row)

Regards

David Rowley

--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
 

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: 9.5 release notes
Следующее
От: Robert Haas
Дата:
Сообщение: Re: WIP: SCRAM authentication