Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-performancepgsql-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

pgsql-performance by date

Next:From: Josh BerkusDate: 2002-10-08 22:44:36
Subject: Re: CHAR, VARCHAR, TEXT (Was Large Databases)
Previous:From: Tom LaneDate: 2002-10-08 15:51:12
Subject: Re: [GENERAL] Large databases, performance

pgsql-hackers by date

Next:From: Joe ConwayDate: 2002-10-08 18:33:03
Subject: Re: Where to call SetQuerySnapshot
Previous:From: Tom LaneDate: 2002-10-08 17:21:25
Subject: Re: Where to call SetQuerySnapshot

pgsql-sql by date

Next:From: Charles HauserDate: 2002-10-08 18:19:15
Subject: Re: Problems Formulating a SELECT
Previous:From: Richard HuxtonDate: 2002-10-08 16:44:15
Subject: Re: Problems Formulating a SELECT

pgsql-general by date

Next:From: Robert TreatDate: 2002-10-08 18:02:57
Subject: Re: phpPgAdmin + PostgreSQL + authentication
Previous:From: Nigel J. AndrewsDate: 2002-10-08 17:21:19
Subject: Re: Efficient date range search?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group