Re: stored procedure optimisation...

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: stored procedure optimisation...
Дата
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2016D1EFB@EXADV1.host.magwien.gv.at
обсуждение исходный текст
Ответ на stored procedure optimisation...  ("Anton Melser" <melser.anton@gmail.com>)
Ответы Re: stored procedure optimisation...  ("Anton Melser" <melser.anton@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Vegard Bønes
Дата:
Сообщение: SQL names for C constants
Следующее
От: "Rafa Comino"
Дата:
Сообщение: Bad performace of a query