Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5FB532E3287 for ; Thu, 29 Nov 2007 19:31:13 -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 22051-04-2 for ; Thu, 29 Nov 2007 19:30:55 -0400 (AST) Received: from smtp5.clear.net.nz (smtp5.clear.net.nz [203.97.33.68]) by postgresql.org (Postfix) with ESMTP id 965BF2E3237 for ; Thu, 29 Nov 2007 19:31:09 -0400 (AST) Received: from zmori.markir.net (121-72-80-54.dsl.telstraclear.net [121.72.80.54]) by smtp5.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JSA00H50JZU5A30@smtp5.clear.net.nz> for pgsql-performance@postgresql.org; Fri, 30 Nov 2007 12:31:08 +1300 (NZDT) Date: Fri, 30 Nov 2007 12:31:01 +1300 From: Mark Kirkwood Subject: Re: TB-sized databases In-reply-to: <1196270576.4246.1246.camel@ebony.site> To: Simon Riggs Cc: Csaba Nagy , Bill Moran , pgsql-performance@postgresql.org Message-id: <474F4BB5.7090305@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit 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> <1196270576.4246.1246.camel@ebony.site> User-Agent: Thunderbird 2.0.0.6 (X11/20071025) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/389 X-Sequence-Number: 27804 Simon Riggs wrote: > 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? > > Knowing how to set it is a problem - but a possibly bigger one is that monster query crippling your DW system, so I'd say lets have it. Cheers Mark