From: Klint Gore <kg@kgb.une.edu.au>
To: pgsql-performance@postgresql.org
Subject: Re: SQL stupid query plan... terrible performance !
Date: Mon, 28 Jun 2004 15:29:57 +1000
Message-ID: <40DFACD5345.1020KG@129.180.47.120> (raw)
In-Reply-To: <16908.1088393386@sss.pgh.pa.us>
References: <40DF684D.9060207@wp.pl>
<16908.1088393386@sss.pgh.pa.us>
On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Jim <jim.jim@wp.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@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 : :
+---------------------------------------+-----------------+
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kg@kgb.une.edu.au
Subject: Re: SQL stupid query plan... terrible performance !
In-Reply-To: <40DFACD5345.1020KG@129.180.47.120>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox