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 CE78B11F61BB for ; Fri, 14 Apr 2006 13:30:39 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -0.327 X-Spam-Level: X-Spam-Status: No, score=-0.327 required=5 tests=[AWL=-1.544, BAYES_00=-2.599, SPF_HELO_SOFTFAIL=2.432, SPF_SOFTFAIL=1.384] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id R92+fQxBMa3v for ; Fri, 14 Apr 2006 13:30:21 -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 0331811F6243 for ; Fri, 14 Apr 2006 13:30:20 -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 k3EGUKHi010152; Fri, 14 Apr 2006 12:30:20 -0400 (EDT) To: Francisco Reyes cc: Marc Cousin , Chris , Pgsql performance Subject: Re: Inserts optimization? In-reply-to: References: <200604141400.38982.mcousin@sigma.fr> Comments: In-reply-to Francisco Reyes message dated "Fri, 14 Apr 2006 12:10:12 -0400" Date: Fri, 14 Apr 2006 12:30:19 -0400 Message-ID: <10151.1145032219@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/337 X-Sequence-Number: 18421 Francisco Reyes writes: > I think I am going to try increasing wal_buffers That will help not at all, if the problem is too-short transactions as it sounds to be. You really need to pester the authors of bacula to try to wrap multiple inserts per transaction. Or maybe find some other software that can do that, if they are uninterested in supporting anything but mysql. regards, tom lane