well i started by creating a table with the data i needed, instead of
working on the big table....that helped a whole lot.
thanks.
On 7/18/06, Michael Fuhr <mike@fuhr.org> wrote:
> 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
>