Performance differences using varchar, char and text

From: Yusuf <yusuf0478(at)netscape(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Performance differences using varchar, char and text
Date: 2003-06-18 20:58:32
Message-ID: 3EF0D278.3050107@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In the Postgres 7.3.3. User Guide section 5.3, it says that there's no performance difference between the three type.
But in 'PostgreSQL Database Performance Tuning' by Jean-Paul ARGUDO (section 5: use correct datatype), it says there
is a performance difference because of you might need more I/O to read the data (which makes sense).

So, is there a performance difference?

Browse pgsql-general by date

  From Date Subject
Next Message Sander Steffann 2003-06-18 21:06:40 Re: plpython? (Was: Re: Damn triggers and NEW)
Previous Message Tom Lane 2003-06-18 20:41:57 Re: A creepy story about dates. How to prevent it?