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