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

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

pgsql-performance by date

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

pgsql-hackers-win32 by date

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

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