Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0755A2E4190 for ; Tue, 5 Feb 2008 17:59:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 66842-04 for ; Tue, 5 Feb 2008 17:59:44 -0400 (AST) Received: from outmail136020.authsmtp.com (outmail136020.authsmtp.com [62.13.136.20]) by postgresql.org (Postfix) with ESMTP id 40CC02E41B4 for ; Tue, 5 Feb 2008 17:59:48 -0400 (AST) Received: from outmail128175.authsmtp.net (outmail128175.authsmtp.net [62.13.128.175]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m15LxGgx091190; Tue, 5 Feb 2008 21:59:17 GMT Received: from [192.168.0.3] (85-211-31-42.dyn.gotadsl.co.uk [85.211.31.42]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m15LxGiS098270; Tue, 5 Feb 2008 21:59:16 GMT Subject: Re: Benchmark Data requested From: Simon Riggs To: "Jignesh K. Shah" Cc: Heikki Linnakangas , Dimitri Fontaine , pgsql-performance@postgresql.org, Greg Smith In-Reply-To: <47A8CC1B.1050000@sun.com> References: <1202150236.4252.521.camel@ebony.site> <200802051506.51581.dfontaine@hi-media.com> <1202221496.4252.680.camel@ebony.site> <200802051815.25800.dfontaine@hi-media.com> <47A8C1B9.10200@enterprisedb.com> <47A8CC1B.1050000@sun.com> Content-Type: text/plain Date: Tue, 05 Feb 2008 22:00:03 +0000 Message-Id: <1202248803.4252.895.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 98246499-d435-11dc-9554-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacxtFaABba1xT HGQLW1xEUlx7XGp/ agwfZQBDYEtPQQZr TkxLXVBXCwUmXB0E elZpC3pyfg1Ef34+ ZENnXj5SVEZ+c0J0 S1MAEW4DeGZhPDMC WUVdcx5UcAJLdhoR aVd4ByJDAzANdhEA MjUdGAoUCH11JSJe QgQEN1FabU8XF3Ym SgkfEC4zEEFt X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:787/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/55 X-Sequence-Number: 28597 On Tue, 2008-02-05 at 15:50 -0500, Jignesh K. Shah wrote: > Is there a way such an operation can be spawned as a worker process? > Generally during such loading - which most people will do during > "offpeak" hours I expect additional CPU resources available. By > delegating such additional work to worker processes, we should be able > to capitalize on additional cores in the system. > > Even if it is a single core, the mere fact that the loading process will > eventually wait for a read from the input file which cannot be > non-blocking, the OS can timeslice it well for the second process to use > those wait times for the index population work. If Dimitri is working on parallel load, why bother? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com