Re: Compression - Mailing list pgsql-general

From Craig Ringer
Subject Re: Compression
Date
Msg-id 4DA78854.8020401@postnewspapers.com.au
Whole thread Raw
In response to Compression  (Yang Zhang <yanghatespam@gmail.com>)
Responses Re: Compression
List pgsql-general
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.

Row compression would be interesting, but I can't imagine it not having
been investigated already.

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: [ADMIN] Streaming Replication limitations
Next
From: John R Pierce
Date:
Subject: Re: Normalize or not?