Postgres Pro
Downloads
Home   >   mailing lists

Again about varchar() - Mailing list pgsql-general

From 李彦 Ian Li
Subject Again about varchar()
Date
Msg-id 469E3ACB.20604@gmail.com
Whole thread Raw
Responses Re: Again about varchar()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)
Next
From: "Benjamin Arai"
Date:
Subject: Parrallel query execution for UNION ALL Queries