Re: CHAR, VARCHAR, TEXT (Was Large Databases)

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

In response to

Responses

Browse pgsql-general by date

  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?

Browse pgsql-hackers by date

  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

Browse pgsql-performance by date

  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

Browse pgsql-sql by date

  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