Re: stored procedure optimisation...

From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
To: "Anton Melser *EXTERN*" <melser(dot)anton(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: stored procedure optimisation...
Date: 2007-02-27 08:28:46
Message-ID: AFCCBB403D7E7A4581E48F20AF3E5DB2016D1EFB@EXADV1.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Partyka 2007-02-27 11:15:03 strange behaviour with sub-select and pl/pgSQL
Previous Message Vegard Bønes 2007-02-27 07:58:19 SQL names for C constants