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 200210081636.40713.josh@agliodbs.com
Whole thread Raw
In response to Re: CHAR, VARCHAR, TEXT (Was Large Databases)  ("Josh Berkus" <josh@agliodbs.com>)
List 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

pgsql-performance by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [HACKERS] [GENERAL] Large databases, performance
Next
From: "Josh Berkus"
Date:
Subject: What does this tell me?