Re: Compression

On Thu, Apr 14, 2011 at 5:07 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> On Thursday, April 14, 2011 4:50:44 pm Craig Ringer wrote:
>
>> On 15/04/2011 7:01 AM, Yang Zhang wrote:
>
>> > Is there any effort to add compression into PG, a la MySQL's
>
>> > row_format=compressed or HBase's LZO block compression?
>
>>
>
>> There's no row compression, but as mentioned by others there is
>
>> out-of-line compression of large values using TOAST.
>
> I could be misunderstanding but I thought compression happened in the row as
> well. From the docs:
>
> "EXTENDED allows both compression and out-of-line storage. This is the
> default for most TOAST-able data types. Compression will be attempted first,
> then out-of-
>
> line storage if the row is still too big. "
>
>>
>
>> Row compression would be interesting, but I can't imagine it not having
>
>> been investigated already.
>
> --
>
> Adrian Klaver
>
> adrian(dot)klaver(at)gmail(dot)com

Already know about TOAST. I could've been clearer, but that's not the
same as the block-/page-level compression I was referring to.

--
Yang Zhang
http://yz.mit.edu/