"David Esposito" <pgsql-general(at)esposito(dot)newnetco(dot)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