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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "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 explain analyze finally)
Date: 2005-03-07 14:45:37
Message-ID: 23086.1110206737@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-performance

"Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
> There is. I beleive QueryPerformanceCounter has sub-mirosecond
> resolution.

> Can we just replace gettimeofday() with a version that's basically:

No, because it's also used for actual time-of-day calls. It'd be
necessary to hack executor/instrument.c in particular.

regards, tom lane

In response to

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message John A Meinel 2005-03-07 16:29:46 Re: [PERFORM] Help with tuning this query (with
Previous Message Magnus Hagander 2005-03-07 14:36:42 Re: [PERFORM] Help with tuning this query (with explain analyze finally)

Browse pgsql-performance by date

  From Date Subject
Next Message tsarevich 2005-03-07 14:46:38 Tuning, configuration for 7.3.5 on a Sun E4500
Previous Message Magnus Hagander 2005-03-07 14:36:42 Re: [PERFORM] Help with tuning this query (with explain analyze finally)