Re: [PERFORM] Help with tuning this query (with

From: "Dave Held" <dave(dot)held(at)arrayservicesgrp(dot)com>
To: "Greg Stark" <gsstark(at)mit(dot)edu>, "John A Meinel" <john(at)arbash-meinel(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Magnus Hagander" <mha(at)sollentuna(dot)net>, "Ken Egervari" <ken(at)upfactor(dot)com>, <pgsql-performance(at)postgresql(dot)org>, <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: [PERFORM] Help with tuning this query (with
Date: 2005-03-07 22:30:40
Message-ID: 49E94D0CFCD4DB43AFBA928DDD20C8F90261846A@asg002.asg.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-performance

> -----Original Message-----
> From: Greg Stark [mailto:gsstark(at)mit(dot)edu]
> Sent: Monday, March 07, 2005 12:06 PM
> To: John A Meinel
> Cc: Tom Lane; Magnus Hagander; Ken Egervari;
> pgsql-performance(at)postgresql(dot)org; pgsql-hackers-win32(at)postgresql(dot)org
> Subject: Re: [pgsql-hackers-win32] [PERFORM] Help with tuning
> this query (with
> [...]
> 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?)

I believe QueryPerformanceCounter() already does this.

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East, Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Dave Held 2005-03-07 22:34:32 Re: [PERFORM] Help with tuning this query (with explain analyze finally)
Previous Message Greg Stark 2005-03-07 18:05:30 Re: [PERFORM] Help with tuning this query (with

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Held 2005-03-07 22:34:32 Re: [PERFORM] Help with tuning this query (with explain analyze finally)
Previous Message Adam Palmblad 2005-03-07 22:26:04 Re: Building postmaster with Profiling Support WAS "Tweaking a C