Eugeny Balakhonov wrote:
> I tries to run simple query:
>
> select * from files_t where parent = 3333
Use this instead:
select * from files_t where parent = '3333';
("parent = 3333::int8" would work as well.)
PostgreSQL (< 7.5) won't consider using an indexscan when the predicate
involves an integer literal and the column datatype is int2 or int8.
-Neil