Alex Mayrhofer <axelm@xxxxxxxx> writes: > a recent REINDEX reduced that index from about 30000 pages to 18000. That's not bloat, that's normal overhead. The traditional rule of thumb for a btree is that at steady state, pages will be about 2/3rds full. REINDEX packs pages to 90% IIRC, but you can't expect that that density will be maintained in the face of heavy update activity. It looks to me like your index is not so far off the rule-of-thumb load factor, and you should just not worry, be happy. If you were finding that your indexes grow to ten times the minimum size, *that* would be worth worrying about. regards, tom lane
