On Wed, Aug 10, 2016 at 4:24 PM, Kisung Kim <ks...@bitnine.net> wrote: > > When I used the index bloating estimation script in > https://github.com/ioguix/pgsql-bloat-estimation, > the result is as follows: >
Regardless of the issue at hand, it might make sense to verify these statistics using pgstattuple - those bloat estimation queries can be wildly off at times. See also https://www.postgresql.org/docs/9.5/static/pgstattuple.html as well as https://www.keithf4.com/checking-for-postgresql-bloat/ Best, Lukas -- Lukas Fittl Skype: lfittl Phone: +1 415 321 0630