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

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: Ron Johnson <ron.l.johnson@cox.net>, pgsql-performance@postgresql.org
Date: 2002-10-08T23:36:40Z
Lists: pgsql-hackers, pgsql-performance
Ron,

> > > > 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?
> > >
> > > ??????
> >
> > In other words, if it ain't broke, don't fix it.
>
> Well, does Really Slow Performance qualify as "broke"?

That's what I was asking.   Can you explain where your slow performance is 
attibutable to the CHAR implementation issues?   I missed that, if it was 
explained earlier in the thread.

-- 
Josh Berkus
josh@agliodbs.com
Aglio Database Solutions
San Francisco