On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Jim <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] : 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 : :
+---------------------------------------+-----------------+
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
