From: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | Re: pgsql: Remove test for pg_stat_reset_shared() in stats.sql |
Date: | 2023-11-28 04:51:33 |
Message-ID: | CALj2ACUnvB_Yo=O1xApBa4CDqQpW-x=QM35GBN1MqVRAxAGXEg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
On Tue, Nov 28, 2023 at 9:51 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> Remove test for pg_stat_reset_shared() in stats.sql
>
> Some buildfarm members have been failing a test related to pg_stat_io,
> as an effect of 23c8c0c8f472 that has switched pg_stat_reset_shared()
> from being a no-op to reset all shared stats types.
>
> This extra reset has the effect to make pg_stat_io's counters low enough
> that little concurrent activity is enough to cause a failure. Another
> thing I have considered is to move this sequence at the end of
> stats.sql, but there are other instabilities, one being pg_stat_wal.
>
> Knowing that there are already tests for the reset of each individual
> shared stats target, this test has limited value, so let's remove it to
> minimize the number of resets done for each shared stats type. This
> should hopefully improve the stability of the whole.
>
> Discussion: https://postgr.es/m/3500949.1700935734@sss.pgh.pa.us
>
> Branch
> ------
> master
>
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/a9a8108411e49c81316a9aba848a7f9ad3d3e939
>
> Modified Files
> --------------
> src/test/regress/expected/stats.out | 44 -------------------------------------
> src/test/regress/sql/stats.sql | 10 ---------
> 2 files changed, 54 deletions(-)
Is there any reason for not removing [1] unneeded statements from
stats.sql like the attached?
--
Bharath Rupireddy
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
Attachment | Content-Type | Size |
---|---|---|
v1-0001-Remove-extraneous-statements-from-stats.sql-test.patch | application/octet-stream | 5.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2023-11-28 04:54:19 | Re: pgsql: Remove test for pg_stat_reset_shared() in stats.sql |
Previous Message | Michael Paquier | 2023-11-28 04:21:13 | pgsql: Remove test for pg_stat_reset_shared() in stats.sql |