performance cost for varchar(20), varchar(255), and text

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: performance cost for varchar(20), varchar(255), and text
Date: 2008-07-05 11:19:52
Message-ID: 801541.60585.qm@web56406.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am tuning a database created by someone else.

I noticed that some column lengths were defined longer than needed.

For example, an Id column is holding a stand length of 20 characters but was defined as varchar(255).

On some other columns, for example, a Description column is supposed to hold less than 100 characters but defined as text.

I am trying to understand the performance impact if a column is over defined in the following cases:

1. char(20) vs varchar(20)

2. varchar(20) vs varchar(255)

3. varchar(255) vs text

thanks,
Jessica

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lew 2008-07-05 15:04:53 Re: performance cost for varchar(20), varchar(255), and text
Previous Message Scott Marlowe 2008-07-04 22:24:32 Re: How many table scans in a delete...