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.klaver@gmail.com