On Thu, Apr 14, 2011 at 5:07 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> 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.klaver@xxxxxxxxx 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
