X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 6E1FA11F73CF for ; Tue, 18 Apr 2006 18:10:13 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.344 X-Spam-Level: X-Spam-Status: No, score=-2.344 required=5 tests=[AWL=0.255, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id EE45L6L5xXgl for ; Tue, 18 Apr 2006 18:10:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3DBD211F72B8 for ; Tue, 18 Apr 2006 18:10:06 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id F069356423; Tue, 18 Apr 2006 16:10:06 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 18 Apr 2006 16:10:06 -0500 Date: Tue, 18 Apr 2006 16:10:05 -0500 From: "Jim C. Nasby" To: Magnus Hagander Cc: Francisco Reyes , Marc Cousin , Chris , Pgsql performance Subject: Re: Inserts optimization? Message-ID: <20060418211005.GI49405@pervasive.com> References: <6BCB9D8A16AC4241919521715F4D8BCEA352AE@algol.sollentuna.se> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA352AE@algol.sollentuna.se> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060418:mha@sollentuna.net::5f4bWPn4A73w2/o5:0000000000000000000 0000000000000000000000000g2y X-Hashcash: 1:20:060418:lists@stringsutils.com::+bpGXpuekq+L5+RY:000000000000000 0000000000000000000000002yzN X-Hashcash: 1:20:060418:mcousin@sigma.fr::riu64ycJOaKQ9Mqc:03yKS X-Hashcash: 1:20:060418:dmagick@gmail.com::MzD4LqUfsku6uDuB:00000000000000000000 0000000000000000000000000hua X-Hashcash: 1:20:060418:pgsql-performance@postgresql.org::EKWbdrWeXElUXHCr:00000 0000000000000000000000002H7T X-Archive-Number: 200604/398 X-Sequence-Number: 18482 On Tue, Apr 18, 2006 at 01:56:44PM +0200, Magnus Hagander wrote: > Bacula already serializes access to the database (they have to support > mysql/myisam), so this shouldn't help. Actually, it might well hurt by > introducing extra delays. You have any contact with the developers? Maybe they're a possibility for our summer of code... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461