Skip site navigation (1) Skip section navigation (2)

Re: optimizing Postgres queries

From: David Teran <david(dot)teran(at)cluster9(dot)com>
To: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: optimizing Postgres queries
Date: 2004-01-05 12:18:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> 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

In response to


pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2004-01-05 12:37:53
Subject: Re: optimizing Postgres queries
Previous:From: Shridhar DaithankarDate: 2004-01-05 12:10:05
Subject: Re: optimizing Postgres queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group