X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2F1B5D1B518 for ; Tue, 21 Oct 2003 17:15:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 06093-10 for ; Tue, 21 Oct 2003 14:14:36 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 3D90FD1B52D for ; Tue, 21 Oct 2003 14:14:35 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3801916; Tue, 21 Oct 2003 10:15:12 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Rhaoni Chiu Pereira Subject: Re: Low Insert/Update Performance Date: Tue, 21 Oct 2003 10:13:53 -0700 User-Agent: KMail/1.4.3 References: <1066659206.3f93ed86b9907@sistemica.info> <200310201007.48534.josh@agliodbs.com> <1066756132.3f95682499d8d@sistemica.info> In-Reply-To: <1066756132.3f95682499d8d@sistemica.info> Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200310211013.53997.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/542 X-Sequence-Number: 4290 Rhaoni, > The delphi program does just one commit for all queries . > I was wandering if ther is some configuration parameters to be changed to > improve the performance ? To help you, we'll need to to trap a query and run an EXPLAIN ANALYZE on it. -- Josh Berkus Aglio Database Solutions San Francisco