Prasanth <dbadmin(at)nqadmin(dot)com> writes:
> Seems like having int2 after code is doing the trick.
> Can you please explain the reasons behind this.
When you write "int2col > 2", the operator that is selected is int2-gt-int4.
However the index on an int2 column can only deal with int2-gt-int2.
8.0 generalized the index mechanism enough to allow int2 indexes to deal
with int2-gt-int4, but in earlier releases you have to take care to make
the constant an int2.
int8 columns have the same issue from the other direction ...
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Postgres Admin||Date: 2005-05-12 19:12:14|
|Subject: ACT! and PostgreSQL|
|Previous:||From: Scott Marlowe||Date: 2005-05-12 19:07:21|
|Subject: Re: memory allocation ; postgresql-8.0|