Skip site navigation (1) Skip section navigation (2)

Re: PL/pgSQL functions - text / varchar - havy performance issue?!

From: Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PL/pgSQL functions - text / varchar - havy performance issue?!
Date: 2003-08-29 15:01:51
Message-ID: 200308291701.51853.o.siegmar@vitrado.de (view raw or flat)
Thread:
Lists: pgsql-performance
Hi Bill,

On Friday 29 August 2003 16:46, you 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.

Nope. I tested you function with the temporary varchar variable...it
is as slow as the 'text-only' varayity.

> Every language I know of hits performance issues when you have to
> convert between types.  I wouldn't _think_ that it would be that
> much work converting between text and varchar, but I'm not familiar
> enough with the server code to know what's actually involved.

I have absolutely no idea how pgsql handles text/varchar stuff
in its server code. But ~ 3 seconds for that small function is ways
to slow in any case.


Bye,
Oliver


In response to

pgsql-performance by date

Next:From: Stephan SzaboDate: 2003-08-29 15:02:26
Subject: Re: bad estimates
Previous:From: Bill MoranDate: 2003-08-29 14:46:44
Subject: Re: PL/pgSQL functions - text / varchar - havy performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group