Re: SQL stupid query plan... terrible 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 : :
+---------------------------------------+-----------------+