Thread: Again about varchar()

Hi all:

I have tables with one or several varchar(n) columns(utf8, n<=200)
which I believe those tables' row length will not exceed the page
length. Will it helps to the performance that I turn off TOAST of
those 'short' varchar() columns by issuing “ALTER TABLE foo ALTER
COLUMN bar SET STORAGE PLAIN”?

Regards
Ian

=?UTF-8?B?5p2O5b2mIElhbiBMaQ==?= <liyan82@gmail.com> writes:
> I have tables with one or several varchar(n) columns(utf8, n<=200)
> which I believe those tables' row length will not exceed the page
> length. Will it helps to the performance that I turn off TOAST of
> those 'short' varchar() columns by issuing “ALTER TABLE foo ALTER
> COLUMN bar SET STORAGE PLAIN”?

No.

            regards, tom lane