Vince Vielhaber <vev@michvhf.com> writes:
> A bit much diskspace for that, isn't it? The data turns over alot.
Yeah, this is one of the scenarios where we desperately need index
compaction. The index pages holding the lower serial numbers are
no doubt empty or nearly so, but there's no mechanism for reclaiming
that space short of rebuilding the index. (BTW you might consider
REINDEX instead of a manual drop/recreate.)
I've looked at the problem a little bit --- there's literature more
recent than Lehmann-Yao that talks about how to do btree compaction
without losing concurrency. But it didn't get done for 7.2.
regards, tom lane