Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D5E012E02FA for ; Mon, 10 Mar 2008 18:59:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20978-05 for ; Mon, 10 Mar 2008 18:59:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail137086.authsmtp.com (outmail137086.authsmtp.com [62.13.137.86]) by postgresql.org (Postfix) with ESMTP id 3F7032E028E for ; Mon, 10 Mar 2008 18:59:23 -0300 (ADT) Received: from outmail128184.authsmtp.net (outmail128184.authsmtp.net [62.13.128.184]) by punt4.authsmtp.com (8.14.1/8.14.1/Kp) with ESMTP id m2ALxJCf071855; Mon, 10 Mar 2008 21:59:19 GMT Received: from [192.168.0.3] (85-211-64-98.dyn.gotadsl.co.uk [85.211.64.98]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m2ALxIaT062266; Mon, 10 Mar 2008 21:59:18 GMT Subject: Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit From: Simon Riggs To: Heikki Linnakangas Cc: Craig Ringer , pgsql-performance@postgresql.org In-Reply-To: <47D5150C.8090802@enterprisedb.com> References: <47D505AF.4040101@postnewspapers.com.au> <47D5150C.8090802@enterprisedb.com> Content-Type: text/plain Date: Mon, 10 Mar 2008 22:00:27 +0000 Message-Id: <1205186427.4269.179.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 3b7dc160-eeed-11dc-9670-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFaQVbYFhD HGQLW1xEUlx7XGp/ agIfZQBDYEtPQQNu TkFBXVBXCwUmXB5w elZnA31ycQdEfng+ ZEZiXD5YDkMuJkd7 QlMBQDhSeGZhPDMC WUZfdx5UcAJLdhoR aVd4ByJDAzANdhEA MjUdGAoUCH1hJT5E ChoJKk1aARxDAiMk Qx0ZWi4iFkoDS2R7 NBE/N1MaAEcYNg0p OlInEVsWLxIIaGxU AkVOSC5fPFQbW3lj FhtXUEJWCjBBXD1a GVU0JVdeX2QKEjZF HE9IUFYUBihCViUA QThBXzdlB18sIkM2 WnNl 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: 200803/209 X-Sequence-Number: 29163 On Mon, 2008-03-10 at 11:01 +0000, Heikki Linnakangas wrote: > According > to oprofile, all the time is spent in TransactionIdIsInProgress. I recently submitted a patch to optimise this. Your comments would be welcome on the patch. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk