Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?

From: David Geier <geidav(dot)pg(at)gmail(dot)com>
To: Lukas Fittl <lukas(at)fittl(dot)com>, John Naylor <johncnaylorls(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, Hannu Krosing <hannuk(at)google(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>, Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?
Date: 2026-03-23 08:00:34
Message-ID: 94366544-c28a-4895-a2a8-19dc58671623@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Lukas!

Thanks for pushing this forward.

On 22.03.2026 19:13, Lukas Fittl wrote:

> TSC calibration improvements:
> - Pass TSC frequency to child processes for EXEC_BACKEND, this makes
> TSC calibration usable on Windows, per off-list suggestion from Andres
> - To support the EXEC_BACKEND change, refactor tsc_frequency_khz to
> have a sentinel value of -1 indicating the TSC was not initialized, vs
> 0 indicating it was initialized but isn't usable, and drop
> has_usable_tsc variable

Have you tested the latest patch set on Windows? Let me know if you want
me to do that.

--
David Geier

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Anthonin Bonnefoy 2026-03-23 08:15:13 Re: Propagate XLogFindNextRecord error to callers
Previous Message Chao Li 2026-03-23 07:56:25 Re: tablecmds: fix bug where index rebuild loses replica identity on partitions