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
you can also play with this-tiny-shiny tool :
http://pgfoundry.org/projects/pgiosim/
It just works and heavily stress the disk with random read/write.
--
F4FQM
Kerunix Flan
Laurent Laborde
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your sub
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
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% on
On Sun, 26 Apr 2009, Kris Jurka wrote:
Scott Marlowe wrote:
On Sun, Apr 26, 2009 at 11:07 AM, Kris Jurka wrote:
As a note for non-JDBC users, the JDBC driver's batch interface allows
executing multiple statements in a single network roundtrip. This is
something you can't get in libpq, so be
On Mon, Apr 27, 2009 at 12:45 AM, Kris Jurka wrote:
> Scott Marlowe wrote:
>>
>> On Sun, Apr 26, 2009 at 11:07 AM, Kris Jurka wrote:
>>>
>>> As a note for non-JDBC users, the JDBC driver's batch interface allows
>>> executing multiple statements in a single network roundtrip. This is
>>> somethi
