Re: Field wise checking the performance.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: dba <dbadbb(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Field wise checking the performance.
Date: 2011-02-14 12:30:03
Message-ID: 4D59204B.9010300@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2011-02-14 13:55:36 Re: How to boost performance of queries containing pattern matching characters
Previous Message dba 2011-02-14 12:06:27 Field wise checking the performance.