Re: index / sequential scan problem

От: Shridhar Daithankar
Тема: Re: index / sequential scan problem
Дата: ,
Msg-id: 3F16D36A.20463.3954D1@localhost
(см: обсуждение, исходный текст)
Ответ на: Re: index / sequential scan problem  (Fabian Kreitner)
Список: pgsql-performance

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

index / sequential scan problem  (Fabian Kreitner, )
 Re: index / sequential scan problem  ("Shridhar Daithankar", )
  Re: index / sequential scan problem  (Fabian Kreitner, )
   Re: index / sequential scan problem  ("Shridhar Daithankar", )
 Re: index / sequential scan problem  (Paul Thomas, )
  Re: index / sequential scan problem  (Fabian Kreitner, )
   Re: index / sequential scan problem  (Paul Thomas, )
    Re: index / sequential scan problem  (Fabian Kreitner, )
     Re: index / sequential scan problem  ("Shridhar Daithankar", )
     Re: index / sequential scan problem  (Jord Tanner, )
     Re: index / sequential scan problem  (Paul Thomas, )
      Re: index / sequential scan problem  (Tom Lane, )
   Re: index / sequential scan problem  (Tom Lane, )
    Re: index / sequential scan problem  (Fabian Kreitner, )
     Re: index / sequential scan problem  (Fabian Kreitner, )
      Re: index / sequential scan problem  (Dennis Björklund, )
       Re: index / sequential scan problem  (Tom Lane, )
        Re: index / sequential scan problem  ("scott.marlowe", )
        Re: index / sequential scan problem  (Dennis Björklund, )

On 17 Jul 2003 at 13:12, Fabian Kreitner wrote:

> At 11:17 17.07.2003, Shridhar Daithankar wrote:
> >How about
> >
> >  where   ma_id  = 2001::integer
> >and     ma_pid = 1097::integer
> >
> >in above query?
>
> I dont really understand in what way this will help the planner but ill try.

That is typecasting. It helps planner understand query in more correct fashion.

Bye
 Shridhar

--
QOTD:    "I may not be able to walk, but I drive from the sitting posistion."



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

От: Jord Tanner
Дата:
Сообщение: Re: Hardware performance
От: Tom Lane
Дата:
Сообщение: Re: index / sequential scan problem