Re: pluggable compression support - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pluggable compression support
Date
Msg-id 20130617054753.GH3753@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: pluggable compression support  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs wrote:
> On 15 June 2013 12:25, Hannu Krosing <hannu@2ndquadrant.com> wrote:
> 
> > additionally it *could* have the property Simon proposed earlier
> > of *uncompressed* pages having some predetermined size, so we
> > could retain optimisations of substring() even on compressed TOAST
> > values.
> 
> That wasn't about having fixed size pages, it was about having a
> function to determine the split points. Reason being we want to use
> some intelligence to split up JSON and XML documents.

Maybe indexed compressed text would be useful:
http://pizzachili.dcc.uchile.cl/

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Department of Redundancy Department: makeNode(FuncCall) division
Next
From: Samrat Revagade
Date:
Subject: Re: Patch for fail-back without fresh backup