Re: Creating index does not make any change in query plan. - Mailing list pgsql-general

On Mon, 17 Feb 2003, Shridhar Daithankar wrote:

Sorry its not exactly 4 bytes, its greate than 4 bytes.

> On 17 Feb 2003 at 15:14, Deepa wrote:
>
> > On Mon, 17 Feb 2003, Shridhar Daithankar wrote:
> >
> > > when you say id=2, it uses default int type which is smallint, AFAIK. So
> > > smallint != bigint and hence planner does not consider using index.
> >
> > But even when a number that has a value of 4 bytes is set in the where
> > condition, the planner is not uses indexed scan. In this case how come
> > this will take the number as small int. Is their any other reason for
> > that.
>
> 4 bytes != bigint.
>
> Bye
>  Shridhar
>
> --
> wok, n.:    Something to thwow at a wabbit.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--

Bye,
Deepa. K

--
Engineer,
Network Management System,
Midas Communication Technologies private Ltd,
Chennai.