Re: Fwd: [GENERAL] 4B row limit for CLOB tables - Mailing list pgsql-hackers

From David Steele
Subject Re: Fwd: [GENERAL] 4B row limit for CLOB tables
Date
Msg-id 54D16A63.7000902@pgmasters.net
Whole thread Raw
In response to Re: Fwd: [GENERAL] 4B row limit for CLOB tables  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
On 2/3/15 5:27 PM, Jim Nasby wrote:
> On 2/3/15 9:50 AM, David Steele wrote:
>> EXTENDED is the default for most TOAST-able types and is still subject
>> to TOAST_TUPLE_THRESHOLD which is normally 2K. EXTERNAL is the same but
>> with no compression.
>>
>> See: http://www.postgresql.org/docs/9.4/static/storage-toast.html
>
> Right. I'd like to be able to set per-column TOAST_TUPLE_THRESHOLD.

No argument there.  There are some columns that I would prefer to always
TOAST because even 2K can be very big for some use cases.

--
- David Steele
david@pgmasters.net



pgsql-hackers by date:

Previous
From: Noah Yetter
Date:
Subject: GRANT USAGE on FOREIGN SERVER exposes passwords
Next
From: BladeOfLight16
Date:
Subject: Re: [GENERAL] How do I bump a row to the front of sort efficiently