Re: Test timings are increasing too fast for cfbot - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Test timings are increasing too fast for cfbot
Date
Msg-id l4xusuyuk6ikwc4yo2jfv3jgirpnsjt43wvkvsvl5pg4uatnat@745jtwac4ebz
Whole thread
In response to Re: Test timings are increasing too fast for cfbot  (Julien Rouhaud <rjuju123@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: Adding REPACK [concurrently]
Next
From: Matheus Alcantara
Date:
Subject: Re: pg_plan_advice