From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | to text or not to text |
Date: | 1999-03-22 23:41:22 |
Message-ID: | XFMail.990322184122.vev@michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)michvhf(dot)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
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Taral | 1999-03-22 23:53:59 | Re: [HACKERS] optimizer and type question |
Previous Message | Erik Riedel | 1999-03-22 23:27:15 | optimizer and type question |