Re: Explaining functions.

On Tue, 23 Jun 2009, Hartman, Matthew wrote:

> Is there a recommended approach when trying to use EXPLAIN on a
> function? Specifically, a function that is more than the typical SELECT
> statement or tiny loop. The one in question that I'm hoping to optimize
> is around 250 lines.

Take a look at
http://www.justatheory.com/computers/databases/postgresql/benchmarking_functions.html
which can help you run stuff multiple times even.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD