Varchar vs. text

From: "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Varchar vs. text
Date: 2001-05-04 16:45:02
Message-ID: 000d01c0d4b9$9f9a4620$6e646464@New6.Travel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Which of varchar(50) and text is more efficient in terms of storage and
retrieval speed for a remarks field that most likely will be left empty and
will not be searched (only retrieved in queries as part of the record).

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-04 16:45:23 Re: VACUUM is hanging
Previous Message newsreader 2001-05-04 16:40:04 Re: a primer on trigger?