Re: keeping track of function execution - Mailing list pgsql-general

From Jasen Betts
Subject Re: keeping track of function execution
Date
Msg-id gtmht4$u26$3@reversiblemaps.ath.cx
Whole thread Raw
In response to keeping track of function execution  (Wojtek <foo@twine.pl>)
List pgsql-general
On 2009-05-03, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Sun, May 3, 2009 at 9:38 AM, Wojtek <foo@twine.pl> wrote:
>> Hi,
>>
>> I have a question on transactions/isolation levels/etc...
>> In my PL/pgSQL function main loop goes through inventory list of active
>> devices, for each one executing processing applicable for given device,
>> like:
>> FOR i in --i is %rowtype
>> select device_id as device_id,
>> type as type
>> from devices_list
>> where active = 1
>> LOOP
>>   (...)
>> -- here is CASE statement, checking value of 'type' parameter
>>  (....)
>> END LOOP; --simple enough, right?
>>
>> This processing is pretty heavy and takes lot of time... so, I'd like to be
>> able to monitor as processing progresses and I need to be able to say:
>> -which devices've been processed already
>> -which ones've not been processed yet
>
> You could raise notice and then tail the logs as it runs.  Or the
> other option mentioned of using dblink() works well too.

you can retrieve notices through libpq. we're experimenting with using them,
and notifies to control the business logic in applications.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Calculating product from rows - (aggregate product )
Next
From: "A. Kretschmer"
Date:
Subject: Re: Calculating product from rows - (aggregate product )