pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: Dave Held <dave.held@arrayservicesgrp.com>
Cc: Greg Stark <gsstark@mit.edu>
Cc: John A Meinel <john@arbash-meinel.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Magnus Hagander <mha@sollentuna.net>
Cc: Ken Egervari <ken@upfactor.com>
Cc: pgsql-performance@postgresql.org
Cc: pgsql-hackers-win32@postgresql.org
Subject: Re: [PERFORM] Help with tuning this query (with
Date: Tue, 8 Mar 2005 02:37:50 +0100
Message-ID: <20050308013750.GA29367@uio.no> (raw)
In-Reply-To: <49E94D0CFCD4DB43AFBA928DDD20C8F90261846C@asg002.asg.local>
References: <49E94D0CFCD4DB43AFBA928DDD20C8F90261846C@asg002.asg.local>

On Mon, Mar 07, 2005 at 06:11:34PM -0600, Dave Held wrote:
>> In which case using it would be a mistake. Since rtdsc doesn't
>> work across processors.
> It doesn't always use RDTSC.  I can't find anything authoritative on
> when it does.  I would assume that it would use RDTSC when available
> and something else otherwise.

RDTSC is a bad source of information for this kind of thing, as the CPU
frequency might vary. Check your QueryPerformanceFrequency() -- most likely
it will not match your clock speed. I haven't tested on a lot of machines,
but I've never seen QueryPerformanceFrequency() ever match the clock speed,
which it most probably would if it was using RDTSC. (I've been told it uses
some other kind of timer available on most motherboards, but I don't know the
details.)

/* Steinar */
-- 
Homepage: http://www.sesse.net/



view thread (16+ messages)  latest in thread

Message-ID: <20050308013750.GA29367@uio.no>
Permalink:  ../20050308013750.GA29367@uio.no/
Also on:    postgresql.org/message-id/20050308013750.GA29367@uio.no

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sgunderson@bigfoot.com, dave.held@arrayservicesgrp.com, gsstark@mit.edu, john@arbash-meinel.com, tgl@sss.pgh.pa.us, mha@sollentuna.net, ken@upfactor.com, pgsql-hackers-win32@postgresql.org
  Subject: Re: [PERFORM] Help with tuning this query (with
  In-Reply-To: <20050308013750.GA29367@uio.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox