X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 68E5711F7DA4 for ; Wed, 19 Apr 2006 12:14:59 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.127 X-Spam-Level: X-Spam-Status: No, score=0.127 required=5 tests=[AWL=0.127] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id CFjqQPtCkf5u for ; Wed, 19 Apr 2006 12:14:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 76F0711F7D76 for ; Wed, 19 Apr 2006 12:14:55 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3JFEqHU026313; Wed, 19 Apr 2006 11:14:52 -0400 (EDT) To: "Magnus Hagander" cc: "Markus Schaber" , "Pgsql performance" Subject: Re: Inserts optimization? In-reply-to: <6BCB9D8A16AC4241919521715F4D8BCEA352C3@algol.sollentuna.se> References: <6BCB9D8A16AC4241919521715F4D8BCEA352C3@algol.sollentuna.se> Comments: In-reply-to "Magnus Hagander" message dated "Wed, 19 Apr 2006 14:11:06 +0200" Date: Wed, 19 Apr 2006 11:14:52 -0400 Message-ID: <26312.1145459692@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/428 X-Sequence-Number: 18512 "Magnus Hagander" writes: >>> Actually, [commit_delay] might well hurt by introducing extra delays. >> >> Well, if you read the documentation, you will see that it >> will only wait if there are at least commit_siblings other >> transactions active. So when Bacula serializes access, there >> will be no delays, as there is only a single transaction alive. > Hm. Right. Well, it still won't help :-) It could actually hurt, because nonzero time is required to go look whether there are any other active transactions. I'm not sure whether this overhead is enough to be measurable when there's only one backend running, but it might be. regards, tom lane