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