Re: Recent 027_streaming_regress.pl hangs - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Recent 027_streaming_regress.pl hangs
Date
Msg-id 20240326075912.sia3wlvnaqnbf47u@awork3.anarazel.de
Whole thread Raw
In response to Re: Recent 027_streaming_regress.pl hangs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Recent 027_streaming_regress.pl hangs
List pgsql-hackers
Hi,

On 2024-03-26 00:54:54 -0400, Tom Lane wrote:
> > I guess I'll try to write a buildfarm database query to extract how long that
> > phase of the test took from all runs on my menagerie, not just the failing
> > one, and see if there's a visible trend.
>
> +1

Only the query for successful runs has finished, and it looks like the error
cse is still going to take a while longer, so here are excerpts from a query
showing how long 027_stream_regress.pl took to succeed:

    sysname    |    date    | count | avg_duration
---------------+------------+-------+--------------

 calliphoridae | 2024-01-29 |    10 |          435
 calliphoridae | 2024-02-05 |    25 |          496
 calliphoridae | 2024-02-12 |    36 |          522
 calliphoridae | 2024-02-19 |    25 |          445
 calliphoridae | 2024-02-26 |    35 |          516
 calliphoridae | 2024-03-04 |    53 |          507
 calliphoridae | 2024-03-11 |    51 |          532
 calliphoridae | 2024-03-18 |    53 |          548
 calliphoridae | 2024-03-25 |    13 |          518

 culicidae     | 2024-01-29 |    11 |          420
 culicidae     | 2024-02-05 |    31 |          485
 culicidae     | 2024-02-12 |    35 |          513
 culicidae     | 2024-02-19 |    29 |          489
 culicidae     | 2024-02-26 |    36 |          512
 culicidae     | 2024-03-04 |    63 |          541
 culicidae     | 2024-03-11 |    62 |          597
 culicidae     | 2024-03-18 |    56 |          603
 culicidae     | 2024-03-25 |    16 |          550

 tamandua      | 2024-01-29 |    13 |          420
 tamandua      | 2024-02-05 |    29 |          433
 tamandua      | 2024-02-12 |    34 |          431
 tamandua      | 2024-02-19 |    27 |          382
 tamandua      | 2024-02-26 |    36 |          492
 tamandua      | 2024-03-04 |    60 |          475
 tamandua      | 2024-03-11 |    56 |          533
 tamandua      | 2024-03-18 |    54 |          527
 tamandua      | 2024-03-25 |    21 |          507

Particularly on tamandua it does look like there has been an upwards trend.

Late, will try to look more in the next few days.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: make dist using git archive
Next
From: Alexander Lakhin
Date:
Subject: Re: ALTER TABLE SET ACCESS METHOD on partitioned tables