pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Oliver Siegmar <o.siegmar@vitrado.de>
To: Bill Moran <wmoran@potentialtech.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PL/pgSQL functions - text / varchar - havy performance issue?!
Date: Fri, 29 Aug 2003 17:01:51 +0200
Message-ID: <200308291701.51853.o.siegmar@vitrado.de> (raw)
In-Reply-To: <3F4F6754.8050900@potentialtech.com>
References: <200308291554.46748.o.siegmar@vitrado.de>
	<3F4F6754.8050900@potentialtech.com>

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




view thread (7+ messages)  latest in thread

Message-ID: <200308291701.51853.o.siegmar@vitrado.de>
Permalink:  ../200308291701.51853.o.siegmar@vitrado.de/
Also on:    postgresql.org/message-id/200308291701.51853.o.siegmar@vitrado.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: o.siegmar@vitrado.de, wmoran@potentialtech.com
  Subject: Re: PL/pgSQL functions - text / varchar - havy performance issue?!
  In-Reply-To: <200308291701.51853.o.siegmar@vitrado.de>
  References: <200308291554.46748.o.siegmar@vitrado.de> <3F4F6754.8050900@potentialtech.com> <200308291701.51853.o.siegmar@vitrado.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox