Thread: Field wise checking the performance.

I have two identical tables. But the with of the fields are different. Need
to know whether changing from varchar(100) to varchar(30) will increase the
performance, or its just the memory access.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Field-wise-checking-the-performance-tp3384348p3384348.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

On 14.02.2011 14:06, dba wrote:
> I have two identical tables. But the with of the fields are different. Need
> to know whether changing from varchar(100) to varchar(30) will increase the
> performance, or its just the memory access.

It will make no difference. The max length is just a constraint on what
values can be stored, it doesn't affect how the strings are stored. In
both cases, the strings are stored in a variable-length format.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com