| From: | David Steele <david(at)pgmasters(dot)net> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Fwd: [GENERAL] 4B row limit for CLOB tables |
| Date: | 2015-02-04 00:40:03 |
| Message-ID: | 54D16A63.7000902@pgmasters.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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(at)pgmasters(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | BladeOfLight16 | 2015-02-04 01:08:06 | Re: oracle to postgres |
| Previous Message | Vasudevan, Ramya | 2015-02-03 22:57:02 | Re: Question on session_replication_role |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | BladeOfLight16 | 2015-02-04 02:33:36 | Re: [GENERAL] How do I bump a row to the front of sort efficiently |
| Previous Message | Tom Lane | 2015-02-04 00:23:23 | Re: pgsql: Add API functions to libpq to interrogate SSL related stuff. |