Again about varchar()

Started by 李彦 Ian Liover 18 years ago2 messagesgeneral
Jump to latest
#1李彦 Ian Li
liyan82@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: 李彦 Ian Li (#1)
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