Re: function taking a long time. any options o speed it up.

On Tue, Jul 18, 2006 at 08:11:40AM -0500, Rhys Stewart wrote:
> i created a function and it takes a long time to run. I was testing it
> as a wrote it and to the first drop table it takes just short of a
> second. however when the rest of the code is added on, it takes
> upwards of 5 minutes. Not the most appropriate thing. Are there any
> tips out there for making functions go faster?

Find out what parts of the function are slow.  Have you used RAISE
to display the function's progress?  Have you executed any of the
queries by hand to see how fast they run?  Have you used EXPLAIN
ANALYZE to see if you could benefit from rewriting a query, adding
indexes, or tuning configuration settings?

The UPDATE statement with the ORs and regular expression matches
looks like it might be slow.  Is it?

--
Michael Fuhr