From: | Alexander Korotkov <akorotkov(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix definition of pg_statio_all_tables view |
Date: | 2020-04-28 08:30:49 |
Message-ID: | E1jTLdh-0004MY-7j@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix definition of pg_statio_all_tables view
pg_statio_all_tables view appears to have a wrong grouping. As the result
numbers of toast index blocks read and hit were multiplied to the number of
table indexes. This commit fixes the view definition.
Backpatching this appears difficult. We don't have a mechanism to patch a
system catalog of existing instances in minor upgrade. We can write a
release notes instruction to do this manually. But per discussion this is
probably not so critical bug for doing such an intrusive fix.
Reported-by: Andrei Zubkov
Discussion: https://postgr.es/m/CAPpHfdtMYkkNudLMG9G0dxX_B%3Dn5sfKzOyxxrvWYtSicaGW0Lw%40mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/ef11051bbe96ea2d06583e4b3b9daaa02657dd42
Modified Files
--------------
src/backend/catalog/system_views.sql | 8 ++++----
src/test/regress/expected/rules.out | 6 +++---
2 files changed, 7 insertions(+), 7 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2020-04-28 11:38:03 | pgsql: Add missing gettext triggers |
Previous Message | Michael Paquier | 2020-04-27 22:58:53 | pgsql: Add more TAP coverage for archive status with crash recovery of |