Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C73612E0106 for ; Tue, 5 Feb 2008 11:34:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55478-01-4 for ; Tue, 5 Feb 2008 11:34:26 -0400 (AST) Received: from outmail128155.authsmtp.co.uk (outmail128155.authsmtp.co.uk [62.13.128.155]) by postgresql.org (Postfix) with ESMTP id 275342E4622 for ; Tue, 5 Feb 2008 11:26:36 -0400 (AST) Received: from outmail128175.authsmtp.net (outmail128175.authsmtp.net [62.13.128.175]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m15FQ1G8050378; Tue, 5 Feb 2008 15:26:02 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 m15FQ0rD079758; Tue, 5 Feb 2008 15:26:00 GMT Subject: Re: Benchmark Data requested From: Simon Riggs To: Richard Huxton Cc: Dimitri Fontaine , pgsql-performance@postgresql.org, "Jignesh K. Shah" , Greg Smith In-Reply-To: <47A87B2E.7050205@archonet.com> References: <1202150236.4252.521.camel@ebony.site> <47A797E5.4000507@sun.com> <200802051506.51581.dfontaine@hi-media.com> <1202221496.4252.680.camel@ebony.site> <47A87618.1090203@archonet.com> <1202223268.4252.707.camel@ebony.site> <47A87B2E.7050205@archonet.com> Content-Type: text/plain Date: Tue, 05 Feb 2008 15:26:47 +0000 Message-Id: <1202225207.4252.718.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: a82b8240-d3fe-11dc-9554-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacxtFaABba1xT HGQLW1xEUVh7W2V/ awsfZQBDYEtPQQZr TkxLXVBXCwUmXB0E cH8eEG1ycAxBfXY+ ZEJjVz4KVEYofUR5 QlMAFjtTeGZhPDMC 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/38 X-Sequence-Number: 28580 On Tue, 2008-02-05 at 15:05 +0000, Richard Huxton wrote: > > Only by locking the table, which serializes access, which then slows you > > down or at least restricts other options. Plus if you use pg_loader then > > you'll find only the first few rows optimized and all the rest not. > > Hmm - the table-locking requirement is true enough, but why would > pg_loader cause problems after the first few rows? It runs a stream of COPY statements, so only first would be optimized with the "empty table optimization". -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com