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

From Alex Hunsaker
Subject Re: Significantly larger toast tables on 8.4?
Date
Msg-id 34d269d40901061230x46cc6bc3v43edfa004cda611b@mail.gmail.com
Whole thread Raw
In response to Re: Significantly larger toast tables on 8.4?  ("Stephen R. van den Berg" <srb@cuci.nl>)
List 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


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: dblink vs SQL/MED - security and implementation details
Next
From: Paul Schlie
Date:
Subject: Re: incoherent view of serializable transactions