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