Andrew Sullivan wrote:
> On Fri, Aug 29, 2003 at 10:46:44AM -0400, Bill Moran wrote:
>>Postgres has to convert the text to a varchar before it can actually
>>do anything. It's possible (though I'm not sure) that it has to
>>do the conversion with each record it looks at.
> It does? According to the docs, varchar is just syntactic sugar for
> text. In fact, text and varchar() are supposed to be exactly the
Really? Well, if I'm wrong, I'm wrong. Wouldn't be the first time.
Have any explanation as to why that function is so slow?
In response to
pgsql-performance by date
|Next:||From: Andrew Sullivan||Date: 2003-08-29 15:54:01|
|Subject: Re: PL/pgSQL functions - text / varchar - havy performance|
|Previous:||From: Alexander Priem||Date: 2003-08-29 15:13:52|
|Subject: Re: Indexing question |