Re: plpgsql function running long, but resources consumption is very low

Hello

without source code we cannot help

regards
Pavel Stehule

2009/4/27 Wojtek <foo(at)twine(dot)pl>:
> Hi,
>
> I'm having serious performance problems with my two plpgsql functions (lots
> of calculations inside, including distance (lat,long) using earthdistance
> etc).
>
> My problem is: both functions are executing for hours (if not days) but
> resource consumption is low (I/O, CPU, memory), like 2-5% only. I'm a bit
> confused on what's going on there... locks? poor resources management by
> Windows? I'm not really sure where the bottleneck might be.
>
> Any hints/recommendations where and how should I look for improvements?
>
> I'm running 8.2 on WinXP.
>
> I'm aware it's kind of hard to say without seeing function's body, but I
> thought I can give a try anyway.
>
> Regards,
> foo
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>