Re: Fwd: [GENERAL] 4B row limit for CLOB tables

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

--
- David Steele
david(at)pgmasters(dot)net