Postgres Pro
Downloads
Home   >   mailing lists

Re: CHAR, VARCHAR, TEXT (Was Large Databases) - Mailing list pgsql-performance

From Josh Berkus
Subject Re: CHAR, VARCHAR, TEXT (Was Large Databases)
Date
Msg-id web-1775407@davinci.ethosmedia.com
Whole thread Raw
In response to Re: [GENERAL] Large databases, performance  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: CHAR, VARCHAR, TEXT (Was Large Databases)  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Ron Johnson
Date:
Subject: Re: [GENERAL] Large databases, performance
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Large databases, performance