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 1w5Fyi-00343J-1C for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 04:36:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5Fyf-00Bi9z-1Y for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 04:36:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w5Fyf-00Bi9r-0d for pgsql-hackers@lists.postgresql.org; Wed, 25 Mar 2026 04:36:21 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5Fyd-00000000uLN-3YrN for pgsql-hackers@postgresql.org; Wed, 25 Mar 2026 04:36:20 +0000 Received: by mail-pj1-x1035.google.com with SMTP id 98e67ed59e1d1-35c124d2613so27857a91.2 for ; Tue, 24 Mar 2026 21:36:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774413379; x=1775018179; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=jt3ozrxb6jqpqYqQFpelGOOgMpIS4J7U9WJKF9EO1Ic=; b=L8YrW6AsAmI4yLMrK32HM/mns80TYIy3k8k6E4AP+N2mHysW2b+A4cru9NIfvcfL6S nzPxc+QIpZ3T+dMOGM3wTDh6m1mTWpoXkBsjDIeSAsFtVCEI+OTZPZh0WzrMufUV3w9X I7CntF/q1HEwne3n8q2Gce/lJz5St884r+3geSSCW2vHMdFfhxoJc9nHnwOZr3rl+f5N j8Pb0O8cE3RBDUwkg90DOfhgaieELOZbrsgZvX1MeuqmdTnAHEz1VCF1YDfBLoPmU669 MaYmn++oL7UMQAqY/TEpK3tshU/QOXB/MtWUGR7Acg9tz1PISWUdp6dnUWr10dEg4kYk Fkgg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774413379; x=1775018179; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=jt3ozrxb6jqpqYqQFpelGOOgMpIS4J7U9WJKF9EO1Ic=; b=QJXzzgB2Ff6O35YhuhhyjIb1SdS1CUaOdm5SYwDw09lMI8BAS99kTWJKZ/NzXazqK6 6ZEolbdJHR01SzAPyvk5uqG0fePh4YYd2wH+AkRmRMGGKxJleyqyJT88z4f83m85FbNZ ijyLBxrlBhNlISgios8m+k8zSVJAdXmF6/1iryLs05A2vGihJHlII4/qk18dlCcf/lSq 7FXqddqM5gl5Xze/XAbe/sRgQ14d0S3TFuldcFUi4QlPqJ6ScoJHVfY/lvaWJpJ+/+Qi TgBa7Bf5dyjOf/Gj2UoaEJZq/dl2Cwf4iKOEZCqn6mQWd4wGQhiPP8sMmNiWDLjk1tOD AMJg== X-Gm-Message-State: AOJu0Yxs0503L9SdHG7oxe8IHROF26+R7TrwMZjo5rY9ssMMYh2eg9mA Y67P/HqaHjs6Zsnkfv+hmDbc5PjarZaI+HJ442JxN2TTa9KCisSpBnJDXLQB2Q== X-Gm-Gg: ATEYQzwVJ8FgskP+FBeBLNY9Jja/ZL6TCLaZ34//4GQ2KfNhxB3sdJJ/vgwj7nw6qJ/ wDkWauL1DTpK8SiBm5SxvYVV7QO+tUz6wuW7yJS8b35Jhou9hWHCDZfb9DhPhF+o1vi7X5pkb25 5LBd+6R7wEr/JSLm9o/eFL8X2APYcgZ6tMep4LWoXCl5x5jZU4khiRKY7dFmNxXaBJyI49k/hnx crm+jOZvZV61T/0uZIYJDMiwgRho/+p+bWyYQFz4i5iGH+bamcxsmUfreWyoShrBAFWN7NvEOqL t0ex/EAeXu/rRh2MYCINmx+/pH30m9A4gKkpgcAURovwihA1ZVbY1yDd69vr7EgQeiRPBvkGZ+k 2/DdmongXpzwnSjSo4FkXH/g1TqEQXf7TRsh5aOGEVvfNEsL4d0bQR+LGsPBT2LWue+idYVxmwm 2jgNzDw1jl2FAmwRBI2F7+PKBKMg== X-Received: by 2002:a17:90b:5109:b0:35b:9777:8bb1 with SMTP id 98e67ed59e1d1-35c0dd951a1mr1614609a91.19.1774413378773; Tue, 24 Mar 2026 21:36:18 -0700 (PDT) Received: from jrouhaud ([115.43.41.38]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-35c03124a87sm5114091a91.3.2026.03.24.21.36.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 24 Mar 2026 21:36:18 -0700 (PDT) Date: Wed, 25 Mar 2026 12:36:12 +0800 From: Julien Rouhaud To: Andres Freund Cc: pgsql-hackers@postgresql.org, Dilip Kumar , Jelte Fennema-Nio , Thomas Munro , Noah Misch Subject: Re: Test timings are increasing too fast for cfbot Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Tue, Mar 24, 2026 at 11:15:32PM -0400, Andres Freund wrote: > > A surprisingly large source of this is psql internal queries. I first ran the > regression tests with pg_stat_statements activated [1] and noticed that a lot > of the queries, by exec and or plan time, are psql queries. > > [1] which annoyingly generates a bunch of test failures due to "Query > Identifier" getting added to tests FWIW `compute_query_id = regress` is supposed to avoid that problem.