Re: Significantly larger toast tables on 8.4? - Mailing list pgsql-hackers

From Stephen R. van den Berg
Subject Re: Significantly larger toast tables on 8.4?
Date
Msg-id 20090106195741.GB28618@cuci.nl
Whole thread Raw
In response to Re: Significantly larger toast tables on 8.4?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Significantly larger toast tables on 8.4?
List pgsql-hackers
Peter Eisentraut wrote:
>(1) Compress everything within reason by default, causing slower retrieval, do 
>not offer substr optimization. [<= 8.3]

>(2) Compress only up to 1 MB, causing faster retrieval, supporting substr 
>optimization. [8.4devel]

>I am personally completely puzzled by option number 2.  Is there even a single 
>use case for that?

I can't imagine one, and (in this thread at least) noone has demonstrated
such; Tom hinted at one, but he didn't elaborate.
-- 
Sincerely,          Stephen R. van den Berg.

"Very funny, Mr. Scott. Now beam down my clothes!"


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Warning about the 8.4 release
Next
From: Joe Conway
Date:
Subject: Re: dblink vs SQL/MED - security and implementation details