Hi,
I have performance problems with a huge database
(there a 2 tables with 40 millions of records) and
many users doing updates and queries on it. I 've
perform severals VACUMM on the database with poor
results.
Each table have an unique index and I added other
indexes to improve the performance. But when there are
inserts (not too many) the performance fall.
What can I do to improve the performace? I hear any
opinion.
Hector Iturre
Ahora pod�s usar Yahoo! Messenger desde tu celular. Aprend� c�mo hacerlo en Yahoo!
M�vil: http://ar.mobile.yahoo.com/sms.html
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly