From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Wojtek <foo(at)twine(dot)pl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: keeping track of function execution |
Date: | 2009-05-03 18:22:10 |
Message-ID: | dcc563d10905031122i725ae341r77a596289005e7b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, May 3, 2009 at 9:38 AM, Wojtek <foo(at)twine(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Buś | 2009-05-03 19:01:24 | Re: could not bind IPv4 socket |
Previous Message | justin | 2009-05-03 16:43:58 | Re: keeping track of function execution |