Re: Significantly larger toast tables on 8.4?

Alex Hunsaker <badalex@gmail.com>

From: "Alex Hunsaker" <badalex@gmail.com>

To: "Stephen R. van den Berg" <srb@cuci.nl>

Cc: "Peter Eisentraut" <peter_e@gmx.net>, pgsql-hackers@postgresql.org, "Alvaro Herrera" <alvherre@commandprompt.com>, "James Mansion" <james@mansionfamily.plus.com>, "Robert Haas" <robertmhaas@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>

Date: 2009-01-06T20:30:11Z

Lists: pgsql-hackers

On Tue, Jan 6, 2009 at 12:57, Stephen R. van den Berg <srb@cuci.nl> wrote:
> 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.

Well that check got removed today anyway see:
http://archives.postgresql.org/pgsql-committers/2009-01/msg00069.php