From: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Fix for pg_statio_all_tables |
Date: | 2020-04-21 10:17:40 |
Message-ID: | CAPpHfdsmj1aR_uq3JSSA_q1ygjQNN2k=PJq2NtrXrcf_ryaSCw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Apr 21, 2020 at 4:38 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> On Tue, Apr 21, 2020 at 02:44:45AM +0300, Alexander Korotkov wrote:
> > Among all the joined tables, only "pg_index I" is expected to have
> > multiple rows associated with single relation. But we do sum() for
> > toast index "pg_index X" as well. As the result, we multiply
> > statistics for toast index by the number of relation indexes. This is
> > obviously wrong.
>
> Oops.
>
> > As a bugfix, I think this should be backpatched. But this patch
> > requires catalog change. Were similar cases there before? If so,
> > how did we resolve them?
>
> A backpatch can happen in such cases, see for example b6e39ca9. In
> this case, the resolution was done with a backpatch to
> system_views.sql and the release notes include an additional note
> saying that the fix applies itself only on already-initialized
> clusters. For other clusters, it was necessary to apply a SQL query,
> given also in the release notes, to fix the issue (just grep for
> CVE-2017-7547 in release-9.6.sgml on the REL9_6_STABLE branch).
Thank you for pointing!
------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2020-04-21 10:19:56 | Re: Fix for pg_statio_all_tables |
Previous Message | Asif Rehman | 2020-04-21 10:16:33 | Re: WIP/PoC for parallel backup |