This was discussed yesterday and previously. Please read the archives.
There is no positive performance reason to use varchar instead of text.
On 2010-07-22 05:38:14PM +0200, Armand Turpel wrote:
> Hi,
> I know this issue was controversed discussed. Some one see no really
> benefits of using varchar against text var. But i'm asking me what if i
> use it as array values. Is there any difference between varchar[126],
> varchar[10000] and text[] else than the number of chars i can store in?
> Performance, memory usage, ....?
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
===========================================================
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===========================================================
