check_postgres icon indicating copy to clipboard operation
check_postgres copied to clipboard
verified publisher icon bucardo

New action for bloat using pg_stattuple

Open phinjensen opened this issue 12 years ago • 1 comments

ID: 22 Version: unspecified Date: 2009-12-03 12:58 EST Author: Greg Sabino Mullane ([email protected])

Use pg_stattuple to get the bloat information, either as a new action or a flag to the current one.

phinjensen avatar Jun 24 '13 17:06 phinjensen

Author: Martin von Oertzen ([email protected]) Date: 2011-06-16 08:57:38 EDT

i have over 10000 relations. i use pg_stattuple manually, after --action=bloat reports problematic tables. because pg_stattuple needs much more time, it might be better, to have cronjobs to generate statistics in the background.

phinjensen avatar Jun 24 '13 17:06 phinjensen