Horton

Re: Test timings are increasing too fast for cfbot

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
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>
Date: 2026-03-26T14:11:18Z
Lists: pgsql-hackers 
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