Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Robert PartykaDate: 2007-02-27 11:15:03
Subject: strange behaviour with sub-select and pl/pgSQL
Previous:From: Vegard B√łnesDate: 2007-02-27 07:58:19
Subject: SQL names for C constants

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group