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

Re: SQL Function Slowness, 8.3.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gavin M(dot) Roy" <gmr(at)myyearbook(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SQL Function Slowness, 8.3.0
Date: 2008-04-16 15:09:47
Message-ID: 8328.1208358587@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Gavin M. Roy" <gmr(at)myyearbook(dot)com> writes:
> In 8.3.0, I'm seeing some oddities with SQL functions which I thought were
> immune to the planner data restrictions of plpgsql functions and the sort.

Without a specific example this discussion is pretty content-free, but
in general SQL functions face the same hazards of bad parameterized
plans as plpgsql functions do.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Mark MielkeDate: 2008-04-16 15:14:26
Subject: Re: SQL Function Slowness, 8.3.0
Previous:From: Gavin M. RoyDate: 2008-04-16 15:06:35
Subject: SQL Function Slowness, 8.3.0

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