From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
---|---|
To: | David Steele <david(at)pgmasters(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Fwd: [GENERAL] 4B row limit for CLOB tables |
Date: | 2015-02-03 22:27:42 |
Message-ID: | 54D14B5E.9000109@BlueTreble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 2/3/15 9:50 AM, David Steele wrote:
> On 2/3/15 10:01 AM, José Luis Tallón wrote:
>
>> Hmmm.... alter column set storage external / set storage extended ?
>>
>> From http://www.postgresql.org/docs/9.4/static/sql-altertable.html :
>> ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL |
>> EXTENDED | MAIN }
>>
>> This would do what you described, right?
>
> 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.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2015-02-03 22:31:29 | Re: [GENERAL] 4B row limit for CLOB tables |
Previous Message | Jim Nasby | 2015-02-03 22:20:00 | Re: array in a store procedure in C |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2015-02-03 22:31:29 | Re: [GENERAL] 4B row limit for CLOB tables |
Previous Message | Jim Nasby | 2015-02-03 22:26:35 | Re: Proposal : REINDEX xxx VERBOSE |