Re: Again about varchar()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 李彦 Ian Li <liyan82(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Again about varchar()
Date: 2007-07-18 16:21:49
Message-ID: 2328.1184775709@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?UTF-8?B?5p2O5b2mIElhbiBMaQ==?= <liyan82(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-07-18 16:30:48 Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Previous Message Benjamin Arai 2007-07-18 16:14:35 Parrallel query execution for UNION ALL Queries