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 707B79DC80A for ; Wed, 22 Mar 2006 05:48:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96953-07 for ; Wed, 22 Mar 2006 05:48:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 861859DC800 for ; Wed, 22 Mar 2006 05:48:00 -0400 (AST) Received: from [192.168.0.5] (unknown [84.12.26.47]) by smtp.nildram.co.uk (Postfix) with ESMTP id 2BD5033BADE; Wed, 22 Mar 2006 09:46:36 +0000 (GMT) Subject: Re: Migration study, step 1: bulk write From: Simon Riggs To: Mikael Carneholm Cc: pgsql-performance@postgresql.org In-Reply-To: <7F10D26ECFA1FB458B89C5B4B0D72C2B08828E@sesrv12.wirelesscar.com> References: <7F10D26ECFA1FB458B89C5B4B0D72C2B08828E@sesrv12.wirelesscar.com> Content-Type: text/plain Date: Wed, 22 Mar 2006 09:46:29 +0000 Message-Id: <1143020789.24487.563.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.096 required=5 tests=[AWL=0.096] X-Spam-Score: 0.096 X-Spam-Level: X-Archive-Number: 200603/442 X-Sequence-Number: 17879 On Wed, 2006-03-22 at 10:04 +0100, Mikael Carneholm wrote: > but that gave a more uneven insert rate Not sure what you mean, but happy to review test results. You should be able to tweak other parameters from here as you had been trying. Your bgwriter will be of some benefit now if you set it aggressively enough to keep up. Your thoughts on this process are welcome... Best Regards, Simon Riggs