Re: keeping track of function execution
От | Scott Marlowe |
---|---|
Тема | Re: keeping track of function execution |
Дата | |
Msg-id | dcc563d10905031122i725ae341r77a596289005e7b@mail.gmail.com обсуждение исходный текст |
Ответ на | keeping track of function execution (Wojtek <foo@twine.pl>) |
Ответы |
Re: keeping track of function execution
PG_Bulkloader (or other tools) and partitions |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: