to text or not to text - Mailing list pgsql-hackers

From Vince Vielhaber
Subject to text or not to text
Date
Msg-id XFMail.990322184122.vev@michvhf.com
Whole thread Raw
Responses Re: [HACKERS] to text or not to text
List pgsql-hackers
The docs say that the text type is the "Best choice" of the character data
types.  It was always my understanding that the text type was stored else-
where in the database and a pointer to it was stored in the actual table.
Does PostgreSQL do this or is a more efficient way been found?  It seems
that it'd be too expensive to store it elsewhere.   I'm making some changes
to a table and wanted to optomize it (varchar vs text).

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null      # include <std/disclaimers.h>
       TEAM-OS2       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================




pgsql-hackers by date:

Previous
From: Erik Riedel
Date:
Subject: optimizer and type question
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] to text or not to text