From: "Christopher Browne" <cbbrowne@acm.org>
> The "empty pages not reclaimed" problem is something that did indeed
> get fixed in the post-7.2 days. I _think_ it was 7.4, but it might
> have been 7.3.
> In short, 7.4.x is indeed a good resolution to your issue.
From: "Tom Lane" <tgl@sss.pgh.pa.us>
>
> That's exactly what I'd expect ...
Thanks both.
So it sounds like:
a) the issue is controllable with a regular (and in our case, just
occasional) reindex without any long term negative consequences
b) Only a dump-restore major version upgrade (which we'll do next time we
can take the system out for long enough) will avoid the issue.
Julian