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

От: Klint Gore
Тема: Re: SQL stupid query plan... terrible performance !
Дата: ,
Msg-id: 40DFACD5345.1020KG@129.180.47.120
(см: обсуждение, исходный текст)
Ответ на: Re: SQL stupid query plan... terrible performance !  (Tom Lane)
Ответы: Re: SQL stupid query plan... terrible performance !  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

SQL stupid query plan... terrible performance !  (Jim, )
 Re: SQL stupid query plan... terrible performance !  (Jeff, )
 Re: SQL stupid query plan... terrible performance !  (Tom Lane, )
  Re: SQL stupid query plan... terrible performance !  (Klint Gore, )
   Re: SQL stupid query plan... terrible performance !  (Tom Lane, )
    Re: SQL stupid query plan... terrible performance !  (Jim, )

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   :            :  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             :                 :
+---------------------------------------+-----------------+


В списке pgsql-performance по дате сообщения:

От: Richard Huxton
Дата:
Сообщение: Re: Query performance
От: Josh Berkus
Дата:
Сообщение: Re: postgres 7.4 at 100%