pgsql: Fix definition of pg_statio_all_tables view

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема pgsql: Fix definition of pg_statio_all_tables view
Дата
Msg-id E1jTLdh-0004MY-7j@gemulon.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: pgsql: Add more TAP coverage for archive status with crash recovery of
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Add missing gettext triggers