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 da...@pgmasters.net
signature.asc
Description: OpenPGP digital signature