Re: SQL Function Slowness, 8.3.0 - Mailing list pgsql-performance

From Tom Lane
Subject Re: SQL Function Slowness, 8.3.0
Date
Msg-id 8328.1208358587@sss.pgh.pa.us
Whole thread Raw
In response to SQL Function Slowness, 8.3.0  ("Gavin M. Roy" <gmr@myyearbook.com>)
Responses Re: SQL Function Slowness, 8.3.0  ("Gavin M. Roy" <gmr@myyearbook.com>)
Re: SQL Function Slowness, 8.3.0  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
"Gavin M. Roy" <gmr@myyearbook.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

pgsql-performance by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: SQL Function Slowness, 8.3.0
Next
From: Mark Mielke
Date:
Subject: Re: SQL Function Slowness, 8.3.0