Re: Performance: sql functions v. plpgsql v. plperl

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Joel Burton <jburton(at)scw(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Performance: sql functions v. plpgsql v. plperl
Date: 2001-04-26 07:38:43
Message-ID: 20010426093843.A373@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 25, 2001 at 05:03:51PM -0400, Tom Lane wrote:
> Joel Burton <jburton(at)scw(dot)org> writes:
> > couldn't the parse tree be cached from this for each backend?
>
> Yes, if someone wanted to work on it ...

It needs global query plan cache and integrate it to SQL function
handler. The usable cache is available at my ftp, but I haven't time
to continue on this. Volunteers? :-)

Karel

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harry Yau 2001-04-26 07:44:08 function return multiple value
Previous Message YekFu.Wong 2001-04-26 06:26:37 Re: Problem with pg_log file corrupted