Feedback-ID: id4a34324:Fastmail
Date: Thu, 26 Mar 2026 10:11:18 -0400
From: Andres Freund <andres@anarazel.de>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: pgsql-hackers@postgresql.org, Dilip Kumar <dilipbalaut@gmail.com>,
	Jelte Fennema-Nio <postgres@jeltef.nl>,
 Thomas Munro <thomas.munro@gmail.com>,
	Noah Misch <noah@leadboat.com>
Subject: Re: Test timings are increasing too fast for cfbot
Message-ID: <l4xusuyuk6ikwc4yo2jfv3jgirpnsjt43wvkvsvl5pg4uatnat@745jtwac4ebz>
References: <mtkrkkcn2tlhytumitpch5ubxiprv2jzvprf5r5m3mjeczvq4q@p6wkzbfxuyv2>
 <ogohyk54vjyejn3kdibrc73wcrdhwsq57fawxitycen6ntbzo3@gnnwuagu2qqj>
 <acNmPGI-CLrwttzc@jrouhaud>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <acNmPGI-CLrwttzc@jrouhaud>
Archived-At: 
 <https://www.postgresql.org/message-id/l4xusuyuk6ikwc4yo2jfv3jgirpnsjt43wvkvsvl5pg4uatnat%40745jtwac4ebz>
Precedence: bulk

Hi,

On 2026-03-25 12:36:12 +0800, Julien Rouhaud wrote:
> 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.

Hm. I guess that should work. Thanks!

It's pretty annoying that one has to manually specify it to keep the tests
passing.  I wonder if we should make pg_regress specify it to avoid that.

Greetings,

Andres Freund