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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
