Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w4aDM-002Kug-01 for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 08:00:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4aDK-00GIyw-1U for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 08:00:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w4aDK-00GIyl-0Y for pgsql-hackers@lists.postgresql.org; Mon, 23 Mar 2026 08:00:42 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w4aDI-00000000dIN-0JYp for pgsql-hackers@postgresql.org; Mon, 23 Mar 2026 08:00:42 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-486fd5360d4so39284615e9.1 for ; Mon, 23 Mar 2026 01:00:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1774252839; x=1774857639; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=Df4E63Hno2bJrguEWr8yX5ioiy7Yf+M++sKBTGzjheg=; b=DFIcfmLtIM4SiamCkBVPEeSio7pllmut+uJB1Pj0RAep2yJAGddg/L2v80wsDXX9LH lUGl3uCMcEHf40WqQGeVcW7F5PdaVxMHfQ73PT9Nn7YsI+XeGjms4yHbH15uP2A80PsG L0fPb267hZEgWRFsvJ8aWDvKdPVjbMpyQGYigjGvgeNeP77CfOTHzfOimh9h+I/lW+Fc vyFyBEQ6AmsDoJz/dVm0a+2OsIUt+DUXxVjtIL3j3+06mxl4d1WfUuFch35XiVF7wRLv 6MBmqGMw4DFIAMRlDVgJoJ083ex5lOK/XfvbT/N/5T/couIXLL/oh3VRQD035m4H/uYN xr0g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774252839; x=1774857639; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Df4E63Hno2bJrguEWr8yX5ioiy7Yf+M++sKBTGzjheg=; b=a1pQlJKPKexYeWUEiZCz7PjMiP0eDHptJghK+cASPXt3QcAJzrj13Fg9FbFsSNOUBg W3AcBD3fgMbfkSYTiKqVAXsHJwmG2SECgburzyaqi4jFyjuXD7/Qm5UfltqA5c6Bv6AD RXy77dTn52uA5UY+OBpc/5jQ9yTy3KSu3z+MqrmmmltJ5UexorwOyW+6OFTs+Ye0NNWe F/zxA/eD8+q3bK9JRtzKhH5DYhYBvusIjkCx8rlIrGkHJ0M/seSqyGdkNZyq0c1rP3fj tEz2hjLnCOfnKAVaCxseppUJoo/P/7CqRyJM1YbEbqQqUg0ePmlEzWWnlseWTkBbFQoP EPxw== X-Forwarded-Encrypted: i=1; AJvYcCWQkrkqZR7vCxhf1BubfznEdqztdcRxxYUIQ7NJFyVwF99sh9xU1vam5l0hq7AhIIV7nSE5vUljkRMyvbN6@postgresql.org X-Gm-Message-State: AOJu0Yzt56RoMLsKAiYRQgvApHUqEVu/IoPAe52Sc2dGBa2f+Ti9MvJt hyhqQoWQBkoHqoIKsUqHU/EmBE493jxF7TNY5CCYmiZlqrBgmlEHJ4sP X-Gm-Gg: ATEYQzyAEmx7HWlY7TMAcdEWbGWfkjfGYEAVRiGd5SsBfZ7AEG8es/7lRY4FU+S9C4V Rd5MWrxcTzAJk0poC34EzwRXtWCT0jSGsJuvqroQpqcnEbi5Vk0R/+eSP+3DCsSkK+WDZEe8gZ8 Kmnfxh28May2/NXh/jf3zo9DGs3hDcKo9Ar+n5EQfi6AJIK3jQT31HStJILncruCOr8MaDB2eQj 1JV3kUzGwZlwGw3s8484AHSYCq+gUkKgM8XqUAsKtudNTotLC0nW56nbOr09WMlYI0SPwPWWNR9 iZmPVrgnbQwimBzeEFeZ2uZ775laL/ySMYVV5WOEdso8jnL1GeV6QoPSctjKzZmnNKbs+Ot0PTl fzSIqnPerygSs9LRcm8alg9fIYOCeZ1RTsafk106t2XUYATgocPOGG1NLUrUyAPkJsWlnwVD1d7 XaPA+9zCogbbQqn9/fQdxRD12tWQ== X-Received: by 2002:a05:600d:4:b0:485:4533:9c47 with SMTP id 5b1f17b1804b1-486fee0f508mr113135845e9.22.1774252838480; Mon, 23 Mar 2026 01:00:38 -0700 (PDT) Received: from [172.31.5.233] ([147.161.235.32]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-43b644ae619sm29016775f8f.5.2026.03.23.01.00.35 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 23 Mar 2026 01:00:36 -0700 (PDT) Message-ID: <94366544-c28a-4895-a2a8-19dc58671623@gmail.com> Date: Mon, 23 Mar 2026 09:00:34 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? To: Lukas Fittl , John Naylor Cc: Andres Freund , Jakub Wartak , Hannu Krosing , Robert Haas , Pavel Stehule , vignesh C , Michael Paquier , Ibrar Ahmed , Maciek Sakrejda , pgsql-hackers References: <1e0462f0-8274-4d57-aa39-9b6ebeb954da@gmail.com> <41528b05-62be-4a5a-abd8-2af2dd84a1be@gmail.com> Content-Language: en-US From: David Geier In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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