From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Lakhin <exclusion@gmail.com>
cc: Nathan Bossart <nathandbossart@gmail.com>,
        Sami Imseih <samimseih@gmail.com>,
        Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>,
        Robert Treat <rob@xzilla.net>, satyanarlapuram@gmail.com,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Add pg_stat_autovacuum_priority
In-reply-to: <5684f479-858e-4c5d-b8f5-bcf05de1f909@gmail.com>
References: <ac_vLKVgs4RYK1P-@nathan>
 <CAA5RZ0sCRjH3xkHFdSXnKysdMZXFyaS_094+K-O_rr4Fkmwc=Q@mail.gmail.com>
 <adB6FQeoUst6gHA0@nathan>
 <CAA5RZ0t6bCR6Pasd_eWqXvyUmrNDWmHUy1yN_Po-c4+b9BtBqQ@mail.gmail.com>
 <adEhRzu4YM7ztLXr@nathan>
 <CAA5RZ0vxby2osMMaCuZ=680tmt583cF9n4rOzTGdsiS-1PJknA@mail.gmail.com>
 <adE9RbcA7lhH_w2d@nathan>
 <CAA5RZ0tYzPDeXbqz9uKacRV2xjD055qrg=s3w2PEQPK8EruuSg@mail.gmail.com>
 <adFiCgN22xJ7Z-oR@nathan>
 <CAA5RZ0vRP-W2wJD2OxEb-=VGj2sp5pMCqHQg9YJiuDVPhaY5jQ@mail.gmail.com>
 <adQsdvPPNviWMCXb@nathan> <5684f479-858e-4c5d-b8f5-bcf05de1f909@gmail.com>
Comments: In-reply-to Alexander Lakhin <exclusion@gmail.com>
	message dated "Wed, 08 Apr 2026 20:00:00 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3077289.1775668665.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 08 Apr 2026 13:17:45 -0400
Message-ID: <3077290.1775668665@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3077290.1775668665%40sss.pgh.pa.us>
Precedence: bulk

Alexander Lakhin <exclusion@gmail.com> writes:
> Please look at a new anomaly, I and SQLsmith have discovered:
> SELECT (SELECT score FROM pg_stat_get_autovacuum_scores() LIMIT 1),
>  =C2=A0=C2=A0=C2=A0 (SELECT score FROM pg_stat_get_autovacuum_scores() L=
IMIT 1);
> ERROR:=C2=A0 detected double pfree in PgStat Snapshot 0x5f6fa4d95d50

Good catch, but you're not the first:

https://www.postgresql.org/message-id/CAHewXNkJKdwb3D5OnksrdOqzqUnXUEMpDam=
1TPW0vfUkW%3D7jUw%40mail.gmail.com

			regards, tom lane