Again about varchar()

From: 李彦 Ian Li <liyan82(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Again about varchar()
Date: 2007-07-18 16:07:39
Message-ID: 469E3ACB.20604@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Arai 2007-07-18 16:14:35 Parrallel query execution for UNION ALL Queries
Previous Message David Fetter 2007-07-18 15:33:25 Re: REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)