Andres Freund <andres@anarazel.de> writes:
> Yea, I tested that - it does help in the integer case. But the bigger
> contributors are the loop over the attributes, and especially the access
> to the datum's compression method. Particularly the latter seems hard to
> avoid.
So maybe we should just dump the promise that VACUUM FULL will recompress
everything? I'd be in favor of that actually, because it seems 100%
outside the charter of either VACUUM FULL or CLUSTER.
regards, tom lane