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

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: CHAR, VARCHAR, TEXT (Was Large Databases)
Date: 2002-10-08 15:33:53
Message-ID: web-1775407@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance pgsql-sql

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 ...

-Josh Berkus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-08 15:51:12 Re: [GENERAL] Large databases, performance
Previous Message Ron Johnson 2002-10-08 15:16:55 Re: [GENERAL] Large databases, performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-10-08 15:51:12 Re: [GENERAL] Large databases, performance
Previous Message Curtis Faith 2002-10-08 15:17:28 Re: Analysis of ganged WAL writes

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2002-10-08 15:51:12 Re: [GENERAL] Large databases, performance
Previous Message Ron Johnson 2002-10-08 15:16:55 Re: [GENERAL] Large databases, performance

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-10-08 15:36:28 Re: Temporary tables and indexes
Previous Message Ron Johnson 2002-10-08 15:16:55 Re: [GENERAL] Large databases, performance