You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Creating an issue to document some discussions I've had about improving index check speed by using pgstatindex().
empty_pages/deleted_pages account for entire pages that are "bloat"
avg_leaf_density provides a % free value for leaf pages that have tuples in them
The number of "internal_pages" as a function of the index size could also be used to find issues where a reindex would be recommended. Would likely have to be a trended metric and then compare numbers before/after a reindex to see when it would be recommended again in the future.
Provide additional columns returned by pgstatindex in the index stats table. May not use them all in the most common output, but if pgstatindex() is already being run, it can at least provide those stats for other use cases.
The text was updated successfully, but these errors were encountered:
Creating an issue to document some discussions I've had about improving index check speed by using pgstatindex().
empty_pages/deleted_pages account for entire pages that are "bloat"
avg_leaf_density provides a % free value for leaf pages that have tuples in them
The number of "internal_pages" as a function of the index size could also be used to find issues where a reindex would be recommended. Would likely have to be a trended metric and then compare numbers before/after a reindex to see when it would be recommended again in the future.
Provide additional columns returned by pgstatindex in the index stats table. May not use them all in the most common output, but if pgstatindex() is already being run, it can at least provide those stats for other use cases.
The text was updated successfully, but these errors were encountered: