Greg Stark <stark(at)enterprisedb(dot)com> wrote:
> You could use "ALTER COLUMN SET STORAGE PLAIN" to disable toasting
on
> that column entirely. This will disable compression as well though.
If
> any record doesn't fit in an 8kB block you'll get an error.
>
> Alternately you could leave the column alone but drop the toast
table
> (presumably having truncated the table first). That will leave
> compression enabled but force the system to avoid storing things
> externally. Again you'll get an error if a record doesn't fit in 8kB
> but only after first trying to compress the data.
Why not use "ALTER COLUMN SET STORAGE MAIN", to allow compression but
avoid external storage?
http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html
-Kevin