Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

our friend the win32 system timer.


  • From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
  • To: <pgsql-hackers-win32(at)postgresql(dot)org>
  • Subject: our friend the win32 system timer.
  • Date: Mon, 16 Aug 2004 15:25:01 -0400
  • Message-id: <6EE64EF3AB31D5448D0007DD34EEB3412A7460(at)Herge(dot)rcsinc(dot)local>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group