Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group