From: Gavin M. Roy <gmr@myyearbook.com>
To: pgsql-performance@postgresql.org
Subject: SQL Function Slowness, 8.3.0
Date: Wed, 16 Apr 2008 11:06:35 -0400
Message-ID: <af1bce590804160806t58f7da1g50fc697dd9e6ab08@mail.gmail.com> (raw)
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.
Basically I have a query which executes in 5ms but when wrapped in a SQL
function, takes 500ms. I've checked all the types passed in to make sure
they match so there is no type conversions taking place in execution.
I'm curious about the validity of my expectation that functions created with
SQL as the language should be as fast as the straight SQL counterpart. I've
previously not run into such an order of magnitude difference in using SQL
functions. Is this a change of behavior in 8.3 from 8.2? Without specific
examples, are there any recommendations on how to speed up these functions?
Thanks,
Gavin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gmr@myyearbook.com
Subject: Re: SQL Function Slowness, 8.3.0
In-Reply-To: <af1bce590804160806t58f7da1g50fc697dd9e6ab08@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox