Horton

Re: Significantly larger toast tables on 8.4?

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

View thread
From: "Stephen R. van den Berg" <srb@cuci.nl>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org, Alvaro Herrera <alvherre@commandprompt.com>, James Mansion <james@mansionfamily.plus.com>, Alex Hunsaker <badalex@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2009-01-06T19:57:41Z
Lists: 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!"