Re: PostgreSQL performance in simple queries

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