Hi, Michael Thank you for your attention!
On Tue, 2021-11-30 at 17:29 +0900, Michael Paquier wrote: > Hmm. Why should we care about invalid indexes at all, including > pg_statio_all_indexes? > I think we should care about them at least because they are exists and can consume resources. For example, invalid index is to be updated by DML operations. Of course we can exclude such indexes from a view using isvalid, isready, islive fields. But in such case we should mention this in the docs, and more important is that the new such states of indexes can appear in the future causing change in a view definition. Counting all indexes regardless of states seems more reasonable to me. -- Andrei Zubkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
