Re: How to determine cause of performance problem? - Mailing list pgsql-performance

From Joost Kraaijeveld
Subject Re: How to determine cause of performance problem?
Date
Msg-id 1127486824.3524.58.camel@Panoramix
Whole thread Raw
In response to Re: How to determine cause of performance problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to determine cause of performance problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Fri, 2005-09-23 at 10:33 -0400, Tom Lane wrote:
> Is the client code running on the same machine as the database server?
> If not, what's the network delay and latency between them?
Yes, it is running on the same machine.


> The major problem you're going to have here is at least one network
> round trip per row inserted --- possibly more, if the jdbc driver is
> doing "helpful" stuff behind your back like starting/committing
> transactions.
OK, I will look into that.

But do you maybe know a pointer to info, or tools that can measure, what
my machine is doing during all the time it is doing nothing? Something
like the performance monitor in Windows but than for Linux?

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to determine cause of performance problem?
Next
From: Tom Lane
Date:
Subject: Re: How to determine cause of performance problem?