Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > oid...any optim...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 3851 of 4424
Post > Topic >>

oid...any optimizations

by sathiya.psql@[EMAIL PROTECTED] ("sathiya psql") Mar 6, 2008 at 12:32 PM

------=_Part_3610_18818695.1204786921357
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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..

------=_Part_3610_18818695.1204786921357
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

i had a table with 50 lakh record...<br><br>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...<br><br>if i remove
the oid column will i get any benefit, what are all the other default
columns created without our knowledge..<br>

------=_Part_3610_18818695.1204786921357--
 




 5 Posts in Topic:
oid...any optimizations
sathiya.psql@[EMAIL PROTE  2008-03-06 12:32:01 
Re: oid...any optimizations
jd@[EMAIL PROTECTED] (&q  2008-03-05 23:06:50 
Re: oid...any optimizations
sathiya.psql@[EMAIL PROTE  2008-03-06 12:43:57 
Re: oid...any optimizations
theo@[EMAIL PROTECTED] (  2008-03-06 09:21:36 
Re: oid...any optimizations
jd@[EMAIL PROTECTED] (&q  2008-03-06 08:28:49 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 8:04:14 CST 2008.