From: | "Dave Held" <dave(dot)held(at)arrayservicesgrp(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Ken Egervari" <ken(at)upfactor(dot)com> |
Cc: | <pgsql-performance(at)postgresql(dot)org>, <pgsql-hackers-win32(at)postgresql(dot)org> |
Subject: | Re: [PERFORM] Help with tuning this query (with explain analyze finally) |
Date: | 2005-03-02 23:01:14 |
Message-ID: | 49E94D0CFCD4DB43AFBA928DDD20C8F90261845C@asg002.asg.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 pgsql-performance |
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, March 02, 2005 4:30 PM
> To: Ken Egervari
> Cc: pgsql-performance(at)postgresql(dot)org;
> pgsql-hackers-win32(at)postgresql(dot)org
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | John A Meinel | 2005-03-02 23:25:10 | Re: Help with tuning this query (with explain analyze finally) |
Previous Message | Tom Lane | 2005-03-02 22:29:48 | Re: [PERFORM] Help with tuning this query (with explain analyze finally) |
From | Date | Subject | |
---|---|---|---|
Next Message | John A Meinel | 2005-03-02 23:25:10 | Re: Help with tuning this query (with explain analyze finally) |
Previous Message | Tom Lane | 2005-03-02 22:29:48 | Re: [PERFORM] Help with tuning this query (with explain analyze finally) |