to text or not to text

Поиск
Список
Период
Сортировка
От Vince Vielhaber
Тема to text or not to text
Дата
Msg-id XFMail.990322184122.vev@michvhf.com
обсуждение исходный текст
Ответы Re: [HACKERS] to text or not to text  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Erik Riedel
Дата:
Сообщение: optimizer and type question
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] to text or not to text