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

Re: [PERFORM] Help with tuning this query (with explain analyze finally)

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 (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-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

pgsql-performance by date

Next:From: John A MeinelDate: 2005-03-02 23:25:10
Subject: Re: Help with tuning this query (with explain analyze finally)
Previous:From: Tom LaneDate: 2005-03-02 22:29:48
Subject: Re: [PERFORM] Help with tuning this query (with explain analyze finally)

pgsql-hackers-win32 by date

Next:From: John A MeinelDate: 2005-03-02 23:25:10
Subject: Re: Help with tuning this query (with explain analyze finally)
Previous:From: Tom LaneDate: 2005-03-02 22:29:48
Subject: Re: [PERFORM] Help with tuning this query (with explain analyze finally)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group