Re: [pgsql-hackers-win32] Help with tuning this query (with - Mailing list pgsql-performance

From Greg Stark
Subject Re: [pgsql-hackers-win32] Help with tuning this query (with
Date
Msg-id 874qfnbac5.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: [pgsql-hackers-win32] Help with tuning this query (with  (John A Meinel <john@arbash-meinel.com>)
List pgsql-performance
John A Meinel <john@arbash-meinel.com> writes:

> Then we would only be wrong for 256 gettimeofday calls. I agree it isn't
> great, though. And probably better to just abstract (possibly just with
> #ifdef) the calls for accurate timing, from the calls that actually need
> the real time.

What would be really neato would be to use the rtdsc (sp?) or equivalent
assembly instruction where available. Most processors provide such a thing and
it would give much lower overhead and much more accurate answers.

The main problem I see with this would be on multi-processor machines.
(QueryPerformanceCounter does work properly on multi-processor machines,
right?)

--
greg

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help trying to tune query that executes 40x slower than in SqlServer
Next
From: "Dave Held"
Date:
Subject: Re: [pgsql-hackers-win32] Help with tuning this query (with