Re: [PERFORM] Help with tuning this query (with explain analyze finally)
"Dave Held" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32,gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
> -----Original Message----- > From: Tom Lane [mailto:[email protected]] > Sent: Wednesday, March 02, 2005 4:30 PM > To: Ken Egervari > Cc: [email protected]; > [email protected] > Subject: Re: [PERFORM] Help with tuning this query (with > explain analyze > finally) > > [...] > Well, what it suggests is that gettimeofday() is only > returning a result good to the nearest millisecond. (Win32 > hackers, does that sound right?) No. There's no such thing as gettimeofday() in Win32. So it must be making some other call, or perhaps an emulation. > [...] > Most modern machines seem to have clocks that can count elapsed > time down to near the microsecond level. Anyone know if it's > possible to get such numbers out of Windows, or are we stuck with > milliseconds? QueryPerformanceCounter() is your friend. http://lists.boost.org/MailArchives/boost/msg45626.php __ David B. Held Software Engineer/Array Services Group 200 14th Ave. East, Sartell, MN 56377 320.534.3637 320.253.7800 800.752.8129 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend