"David Esposito" <pgsql-general@xxxxxxxxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
