X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7B896D9196 for ; Fri, 23 Sep 2005 11:47:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88987-03 for ; Fri, 23 Sep 2005 14:47:00 +0000 (GMT) Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by svr1.postgresql.org (Postfix) with ESMTP id 63623D709A for ; Fri, 23 Sep 2005 11:47:00 -0300 (ADT) Received: obelix.askesis.nl 172.31.0.1 from 172.31.1.8 172.31.1.8 via HTTP with MS-WebStorage 6.0.6249 Received: from Panoramix by obelix.askesis.nl; 23 Sep 2005 16:47:04 +0200 Subject: Re: How to determine cause of performance problem? From: Joost Kraaijeveld To: Tom Lane Cc: Arjen van der Meijden , Michael Stone , pgsql-performance@postgresql.org In-Reply-To: <3711.1127485986@sss.pgh.pa.us> References: <1127458167.2475.105.camel@Panoramix> <20050923095517.GW14918@mathom.us> <1127470875.3524.17.camel@Panoramix> <20050923110500.GX14918@mathom.us> <4333E4DB.4020206@tweakers.net> <1127482558.3524.23.camel@Panoramix> <3711.1127485986@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Fri, 23 Sep 2005 16:47:04 +0200 Message-Id: <1127486824.3524.58.camel@Panoramix> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.092 required=5 tests=[AWL=0.042, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/296 X-Sequence-Number: 14604 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