Re: index bloat

"David Esposito" <pgsql-general@esposito.newnetco.com> writes:
> Size of "problem" table: 6 million rows
> Ballpark guess on INSERT/UPDATE/DELETE queries on this table: over 1
> million/day
> ...
> I do a nightly VACUUM (not VACUUM FULL)

Given those parameters, you should expect a "slack" proportion of about
1/6th of the table.  Many of the indexes you show seem to be in that
ballpark --- do you have any idea what's different about the two that
are not?

            regards, tom lane