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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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