Datatype sizes; a space and speed issue?

From: Madison Kelly <linux(at)alteeve(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Datatype sizes; a space and speed issue?
Date: 2004-06-23 03:26:58
Message-ID: 40D8F882.4020507@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi again,

Something I have been wondering about and haven't found an answer to
yet is how the size of a datatype (I hope that is the right term)
effects performance. What effect is there if I specify "TEXT" instead of
say "VARCHAR(255)"? How much benefit is there do being more aggresive
and say cutting it in half again by using "VARCHAR(128)"?

I hope this isn't too basic a question! Thanks!

Madison

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joel Matthew 2004-06-23 03:28:27 incremental backups?
Previous Message Scott Ribe 2004-06-23 01:55:10 Re: Connection gets into state where all queries fail