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

2009-04-27 Thread Scott Carey
On 4/27/09 2:56 AM, "Pavel Stehule" wrote: > Hello > > without source code we cannot help > That's not true. We can only go so far without source, but the general problem of "what might the bottleneck be if it doesn't appear to be CPU or disk" can be investigated significantly without source

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

2009-04-27 Thread Pavel Stehule
Hello without source code we cannot help regards Pavel Stehule 2009/4/27 Wojtek : > 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 execu