our friend the win32 system timer.
| От | Merlin Moncure |
|---|---|
| Тема | our friend the win32 system timer. |
| Дата | |
| Msg-id | 6EE64EF3AB31D5448D0007DD34EEB3412A7460@Herge.rcsinc.local обсуждение исходный текст |
| Ответы |
Re: our friend the win32 system timer.
Re: our friend the win32 system timer. |
| Список | pgsql-hackers-win32 |
Depending on how you look at it, this may be a semi-serious problem in win32. pg uses the C library time routines to calculate elapsed time and supply values. Unfortunately, this value is only updated for each timeslice allocated to the thread. The resolution of this timer is about 10 ms... This means that a table with a timestamp column defaulted to now() and a unique constraint on that column will have a very high chance of constraint violations. This might happen when reading in values from a script, and it works fine on Linux. A side issue is that psql analyze timings are not useful below 10 ms. Should the win32 high performance counter, QueryPerformanceCounter, be introduced? Merlin
В списке pgsql-hackers-win32 по дате отправления: