Datatype sizes; a space and speed issue? - Mailing list pgsql-general

From Madison Kelly
Subject Datatype sizes; a space and speed issue?
Date
Msg-id 40D8F882.4020507@alteeve.com
Whole thread Raw
Responses Re: Datatype sizes; a space and speed issue?
Re: Datatype sizes; a space and speed issue?
List 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

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Connection gets into state where all queries fail
Next
From: Joel Matthew
Date:
Subject: incremental backups?