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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD