Skip site navigation (1) Skip section navigation (2)

Re: SQL stupid query plan... terrible performance !

From: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: SQL stupid query plan... terrible performance !
Date: 2004-06-28 05:29:57
Message-ID: 40DFACD5345.1020KG@129.180.47.120 (view raw or flat)
Thread:
Lists: pgsql-performance
On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Jim <jim(dot)jim(at)wp(dot)pl> 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(at)kgb(dot)une(dot)edu(dot)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             :                 :
+---------------------------------------+-----------------+

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2004-06-28 05:48:43
Subject: Re: SQL stupid query plan... terrible performance !
Previous:From: Mischa SandbergDate: 2004-06-28 05:23:53
Subject: Re: Query performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group