| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | <martin(dot)chantler(at)convergys(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Which character data type to use? |
| Date: | 2000-12-12 16:07:03 |
| Message-ID: | Pine.LNX.4.30.0012121701590.1538-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
martin(dot)chantler(at)convergys(dot)com writes:
> For storing character data such as surname, email address which
> is the best data type to use?
See FAQ item 4.15. VARCHAR is my suggestion.
> Can each of these be indexed???
Yes
> Which of these is fastest considering hard disks are so cheap I don't much care
> about which takes the most bytes!
You're dead wrong if you're thinking that way. The issue is not that hard
disk space is cheap, it's that cache memory is scarce.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edward Q. Bridges | 2000-12-12 16:08:09 | Re: manuals |
| Previous Message | George Johnson | 2000-12-12 16:06:08 | Re: Reliability Stability of PgSQL & it's JDBC driver |