• A
    Add pgstattuple_approx() to the pgstattuple extension. · 5850b20f
    Andres Freund 提交于
    The new function allows to estimate bloat and other table level statics
    in a faster, but approximate, way. It does so by using information from
    the free space map for pages marked as all visible in the visibility
    map. The rest of the table is actually read and free space/bloat is
    measured accurately.  In many cases that allows to get bloat information
    much quicker, causing less IO.
    
    Author: Abhijit Menon-Sen
    Reviewed-By: Andres Freund, Amit Kapila and Tomas Vondra
    Discussion: 20140402214144.GA28681@kea.toroid.org
    5850b20f
pgstatapprox.c 7.1 KB