Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> However, as integers, there would have to be a lot of duplicate values
> before compression would be a win.
Not necessarily. If for instance most of the values fit in int2, then
the upper zero bytes would be fodder for compression. (If they *all*
fit in int2 then of course he's missing a trick...) The fact that they
are successfully using row compression on their old platform indicates
that there's some win available there.
regards, tom lane