Re: oid...any optimizations

On Thu, 2008-03-06 at 12:32 +0530, sathiya psql wrote:
> i had a table with 50 lakh record...
> 
> it has a column called oid ( obviously all the tables will have
> this ), but while doing any operation it is getting slow because of
> the number of records...
> 
> if i remove the oid column will i get any benefit, what are all the
> other default columns created without our knowledge..

Probably not

Also - do not remove oid if your sql operations require it. 

A 'create index x_oid_idx on table x (oid)' might help. 

Also see EXPLAIN in the manual.

-- 
Regards
Theo