Re: optimizing Postgres queries

Hi,

> The performance will likely to be the same. Its just that integer
> happens to
> be default integer type and hence it does not need an explicit
> typecast. ( I
> don't remember exactly which integer is default but it is either of
> int2,int4
> and int8...:-))
>
The docs say int4 is much faster than int8, but i will check this.

> The performance diffference is likely due to use of index, which is in
> turn
> due to typecasting. If you need bigint, you should use them. Just
> remember to
> typecast whenever required.

This is my bigger problem: i am using EOF (OR mapping tool) which frees
me more or less form writing a lot of SQL. If i need to typecast to use
an index then i have to see how to do this with this framework.

Regards David