Re: Test timings are increasing too fast for cfbot

From: Andres Freund <andres(at)anarazel(dot)de>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>
Subject: Re: Test timings are increasing too fast for cfbot
Date: 2026-03-26 14:11:18
Message-ID: l4xusuyuk6ikwc4yo2jfv3jgirpnsjt43wvkvsvl5pg4uatnat@745jtwac4ebz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matheus Alcantara 2026-03-26 14:30:40 Re: pg_plan_advice
Previous Message Antonin Houska 2026-03-26 14:06:29 Re: Adding REPACK [concurrently]