Again about varchar()
Started by 李彦 Ian Liover 18 years ago2 messagesgeneral
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
Re: Again about varchar()
=?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