Re: Higher TOAST compression.

From: Laurent Laborde <kerdezixe(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Higher TOAST compression.
Date: 2009-07-28 15:44:38
Message-ID: 8a1bfe660907280844g2fa89e3ck39b181f06bce3c8e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 28, 2009 at 2:36 PM, Laurent Laborde<kerdezixe(at)gmail(dot)com> wrote:
> I'm currently rewriting the whole toaster stuff to simply define :
> - a compression threshold (size limit to compress, in Nth of page)
> - an external threshold (size limit to externalize compressed data, in
> Nth of page)
>
> i keep the TOAST_INDEX_TARGET and EXTERN_TUPLES_PER_PAGE.
>
> I expect a lot of trial and error as it will my first real patch.
> http://github.com/ker2x/AkaneSQL/tree/master as usual.

Rewritten. All 114 tests passed.
I'm testing it on our plateform (currently replicating ~80GB of data
via slony, heavy read test will come later).

If it works, and if you're interested, i may try to write a patch for 8.5.

*hugs*

--
Laurent "ker2x" Laborde
Sysadmin @ http://www.over-blog.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2009-07-28 15:46:31 Re: Index-only-scans, indexam API changes
Previous Message Teodor Sigaev 2009-07-28 15:01:30 Re: Filtering dictionaries support and unaccent dictionary