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.
In response to
pgsql-performance by date
|Next:||From: Shaun Thomas||Date: 2011-02-14 13:55:36|
|Subject: Re: How to boost performance of queries containing pattern
|Previous:||From: dba||Date: 2011-02-14 12:06:27|
|Subject: Field wise checking the performance.|