| 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: | Whole Thread | Raw Message | 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 |