In response to Tom Lane <tgl@xxxxxxxxxxxxx>: > Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx> writes: > > It wasn't the fact that it bloated that surprised me. It was the > > _magnitude_ of bloat that I wasn't expecting, as well as the fact that > > it was _all_ _index_ bloat. > > Um, no, you had plenty of table *and* index bloat before. The problem > here is that VACUUM FULL fixed all the table bloat whilst making the > index situation worse :-( Right. It doesn't _look_ that way from the graph, but that's because I only graph total DB size. I expect if I graphed data and index size separately, it would be evident. At this point, I'm going to assume that my question of, "Is this 4x bloat strange enough to warrant further investigation" is "no". It seems like this amount of bloat isn't terribly unusual, and that the people working on improving this sort of thing already have enough examples of it. Thanks to everyone for the replies. -- Bill Moran Collaborative Fusion Inc.
