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