Re: PL/pgSQL functions - text / varchar - havy performance

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PL/pgSQL functions - text / varchar - havy performance
Date: 2003-08-29 15:54:01
Message-ID: 20030829155401.GM19388@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Aug 29, 2003 at 11:34:13AM -0400, Bill Moran wrote:
> Have any explanation as to why that function is so slow?

Sorry, no. It might have to do with the planning, though. I believe
the funciton is planned the first time it is run. It may need to be
marked as "STABLE" in order to use any indexes, and that could be
part of the problem.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ken Geis 2003-08-29 16:06:31 Re: bad estimates
Previous Message Bill Moran 2003-08-29 15:34:13 Re: PL/pgSQL functions - text / varchar - havy performance