X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 04E59D1B25F for ; Mon, 28 Jun 2004 02:21:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55835-04 for ; Mon, 28 Jun 2004 05:21:53 +0000 (GMT) Received: from mailhub2.une.edu.au (mailhub2.une.edu.au [129.180.1.142]) by svr1.postgresql.org (Postfix) with ESMTP id AA503D1B258 for ; Mon, 28 Jun 2004 02:21:51 -0300 (ADT) Received: from icarus.une.edu.au (icarus.une.edu.au [129.180.47.120]) by mailhub2.une.edu.au (Postfix) with ESMTP id B7ED17ECD for ; Mon, 28 Jun 2004 15:21:50 +1000 (EST) Received: from kgb (kgb.une.edu.au [129.180.47.225]) by icarus.une.edu.au (8.12.8/8.12.8) with SMTP id i5S5QaNv008311 for ; Mon, 28 Jun 2004 15:26:36 +1000 Date: Mon, 28 Jun 2004 15:29:57 +1000 From: Klint Gore To: pgsql-performance@postgresql.org Subject: Re: SQL stupid query plan... terrible performance ! In-Reply-To: <16908.1088393386@sss.pgh.pa.us> References: <40DF684D.9060207@wp.pl> <16908.1088393386@sss.pgh.pa.us> Message-Id: <40DFACD5345.1020KG@129.180.47.120> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver 1.25.06 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/272 X-Sequence-Number: 7330 On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane wrote: > Jim writes: > > I have one performance issue... and realy have no idea what's going on... > > [yawn...] Cast the constants to bigint. See previous discussions. > > regards, tom lane Would there be any way of adding some sort of indicator to the plan as to why sequential was chosen? eg Seq Scan on upload (type mismatch) (cost....) Seq Scan on upload (statistics) (cost....) Seq Scan on upload (catch-all) (cost....) klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : kg@kgb.une.edu.au : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+