| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: CHAR, VARCHAR, TEXT (Was Large Databases) |
| Date: | 2002-10-08 17:42:20 |
| Message-ID: | 1034098940.1336.39.camel@haggis |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-performance pgsql-sql |
On Tue, 2002-10-08 at 10:33, Josh Berkus wrote:
> Ron, Shridhar,
>
> Maybe I missed something on this thread, but can either of you give me
> an example of a real database where the PostgreSQL approach of "all
> strings are TEXT" versus the more traditional CHAR implementation have
> resulted in measurable performance loss?
??????
> Otherwise, this discussion is rather academic ...
--
+------------------------------------------------------------+
| Ron Johnson, Jr. mailto:ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| "they love our milk and honey, but preach about another |
| way of living" |
| Merle Haggard, "The Fighting Side Of Me" |
+------------------------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2002-10-08 18:02:57 | Re: phpPgAdmin + PostgreSQL + authentication |
| Previous Message | Nigel J. Andrews | 2002-10-08 17:21:19 | Re: Efficient date range search? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-10-08 18:33:03 | Re: Where to call SetQuerySnapshot |
| Previous Message | Tom Lane | 2002-10-08 17:21:25 | Re: Where to call SetQuerySnapshot |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-10-08 22:44:36 | Re: CHAR, VARCHAR, TEXT (Was Large Databases) |
| Previous Message | Tom Lane | 2002-10-08 15:51:12 | Re: [GENERAL] Large databases, performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Hauser | 2002-10-08 18:19:15 | Re: Problems Formulating a SELECT |
| Previous Message | Richard Huxton | 2002-10-08 16:44:15 | Re: Problems Formulating a SELECT |