From: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
---|---|
To: | Postgresql Novice List <pgsql-novice(at)postgresql(dot)org> |
Subject: | when to use char, varchar or text |
Date: | 2002-05-23 12:04:39 |
Message-ID: | 20020523120439.GA13898@campbell-lange.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm making a table to hold a queue of incoming and outgoing email
messages. I'm confused about using char, varchar or text fields - I
imagine they are searchable (without and index) with decreasing speed
from char to text. Is that right?
The (very simplified) column setup I have includes:
to varchar(200)
from varchar(200)
cc varchar(200)
subject text
body text
Should I make the columns all of type text so that large numbers of 'to'
recipients can be supported?
Some general advice greatly appreciated.
p.s. I expect the number of rows in this table to be less than 5000.
--
Rory Campbell-Lange
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2002-05-23 12:28:44 | Re: optimising data load |
Previous Message | Pierre-Alexis PAQUIN | 2002-05-23 10:15:58 | I WANT TO UNSUBSCRIBE |