Re: [PERFORM] oid...any optimizations

2008-03-06 Thread Joshua D. Drake
On Thu, 6 Mar 2008 12:43:57 +0530 "sathiya psql" <[EMAIL PROTECTED]> wrote: > > > > Actually it isn't obvious as oids have been deprecated for years. > > > no in my version it is now also available I didn't say they were gone. I said they are deprecated. You should not be using them. > >

Re: [PERFORM] oid...any optimizations

2008-03-05 Thread Theo Kramer
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

Re: [PERFORM] oid...any optimizations

2008-03-05 Thread sathiya psql
> > Actually it isn't obvious as oids have been deprecated for years. no in my version it is now also available > > > What version of ancient PostgreSQL are you running exactly? postgresql 7.4

Re: [PERFORM] oid...any optimizations

2008-03-05 Thread Joshua D. Drake
On Thu, 6 Mar 2008 12:32:01 +0530 "sathiya psql" <[EMAIL PROTECTED]> 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... Actually it isn'

[PERFORM] oid...any optimizations

2008-03-05 Thread sathiya psql
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 witho