Postgres Pro
Downloads
Home   >   mailing lists

Re: Again about varchar() - Mailing list pgsql-general

From Tom Lane
Subject Re: Again about varchar()
Date
Msg-id 2328.1184775709@sss.pgh.pa.us
Whole thread Raw
In response to Again about varchar()  (李彦 Ian Li <liyan82@gmail.com>)
List pgsql-general
Tree view 
=?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

pgsql-general by date:

Previous
From: "Benjamin Arai"
Date:
Subject: Parrallel query execution for UNION ALL Queries
Next
From: "Jonah H. Harris"
Date:
Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries