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 gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
