Re: stored procedure optimisation... - Mailing list pgsql-general

From Albe Laurenz
Subject Re: stored procedure optimisation...
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2016D1EFB@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to stored procedure optimisation...  ("Anton Melser" <melser.anton@gmail.com>)
Responses Re: stored procedure optimisation...  ("Anton Melser" <melser.anton@gmail.com>)
List pgsql-general
Anton Melser wrote:
> I need to analyse some html to get some links out, and with only 25
> lines in exports_tmp_links (and text_to_parse no more than around
> 10KB) this function has taken 10 minutes and counting. Something
> horribly wrong is going on here! Can someone give me any pointers?

I bet that you are running into an endless loop there.

Try adding a few RAISE statements to find out what is happening,
something like

RAISE NOTICE 'I am here, and myvar = % and thatvar = %', myvar, thatvar;

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Vegard Bønes
Date:
Subject: SQL names for C constants
Next
From: "Rafa Comino"
Date:
Subject: Bad performace of a query