Skip site navigation (1) Skip section navigation (2)

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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Wojtek <foo(at)twine(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: plpgsql function running long, but resources consumption is very low
Date: 2009-04-27 09:56:12
Message-ID: 162867790904270256y7b053b1pd26db99a8977f99e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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
>

In response to

Responses

pgsql-performance by date

Next:From: Laurent LabordeDate: 2009-04-27 15:33:46
Subject: Re: Using IOZone to simulate DB access patterns
Previous:From: WojtekDate: 2009-04-27 09:39:38
Subject: plpgsql function running long, but resources consumption is very low

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group