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
In response to
pgsql-general by date
|Next:||From: David Wheeler||Date: 2004-08-26 16:36:20|
|Subject: Re: UTF-8 and LIKE vs =|
|Previous:||From: Tom Lane||Date: 2004-08-26 16:23:50|
|Subject: Re: R: space taken by a row & compressed data |