Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D984E2E00C2 for ; Wed, 28 Nov 2007 13:23:07 -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 51040-04 for ; Wed, 28 Nov 2007 13:23:03 -0400 (AST) Received: from outmail128086.authsmtp.net (outmail128086.authsmtp.net [62.13.128.86]) by postgresql.org (Postfix) with ESMTP id 90AC92E008F for ; Wed, 28 Nov 2007 13:23:02 -0400 (AST) Received: from outmail128176.authsmtp.co.uk (outmail128176.authsmtp.co.uk [62.13.128.176]) by punt4.authsmtp.com (8.14.1/8.14.1/Kp) with ESMTP id lASHMe0J068230; Wed, 28 Nov 2007 17:22:41 GMT Received: from [192.168.0.3] (85-211-24-246.dyn.gotadsl.co.uk [85.211.24.246]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id lASHMaQL006179; Wed, 28 Nov 2007 17:22:37 GMT Subject: Re: TB-sized databases From: Simon Riggs To: Csaba Nagy Cc: Bill Moran , pgsql-performance@postgresql.org In-Reply-To: <1196257702.31315.6.camel@PCD12478> References: <4544e0330711260904g45d893a8ub1731e245aa8fc84@mail.gmail.com> <474B1407.3090607@laotraesquina.com.ar> <474B1B8C.1030505@gmail.com> <4544e0330711271218h56ce4cc3p280a9fefff24583d@mail.gmail.com> <1196197045.4246.1154.camel@ebony.site> <474CA2FA.2020201@laotraesquina.com.ar> <20071128082716.91bbad9c.wmoran@collaborativefusion.com> <1196257702.31315.6.camel@PCD12478> Content-Type: text/plain Date: Wed, 28 Nov 2007 17:22:56 +0000 Message-Id: <1196270576.4246.1246.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 83de9a90-9dd6-11dc-814e-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFag1bY1ZH HGQLW1NEUVp7W2F/ aA0fZQBDYEtPQQdu TkpNRE1QERpoT0Bw ZWZjA3gOdwVAeXl5 K0dnXXIVVEcuIE8s S05JHDlSY3phaTRM TUhZc1ZJcANLfxdA PlN4UyBcLwdSbGoL JyIJERcLGAAXFA4Q WQAfIF5aTU8XFzQ1 XB0ZdXVz X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/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: 200711/359 X-Sequence-Number: 27774 On Wed, 2007-11-28 at 14:48 +0100, Csaba Nagy wrote: > In fact an even more useful option would be to ask the planner to throw > error if the expected cost exceeds a certain threshold... Well, I've suggested it before: statement_cost_limit on pgsql-hackers, 1 March 2006 Would people like me to re-write and resubmit this patch for 8.4? Tom's previous concerns were along the lines of "How would know what to set it to?", given that the planner costs are mostly arbitrary numbers. Any bright ideas, or is it we want it and we don't care about the possible difficulties? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com