Greg Stark <st...@enterprisedb.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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers