Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A38F8475E41 for ; Thu, 12 Dec 2002 07:56:13 -0500 (EST) Received: from web20108.mail.yahoo.com (web20108.mail.yahoo.com [216.136.226.45]) by postgresql.org (Postfix) with SMTP id DE38C475E2E for ; Thu, 12 Dec 2002 07:56:12 -0500 (EST) Message-ID: <20021212125615.23571.qmail@web20108.mail.yahoo.com> Received: from [200.45.99.243] by web20108.mail.yahoo.com via HTTP; Thu, 12 Dec 2002 09:56:15 ART Date: Thu, 12 Dec 2002 09:56:15 -0300 (ART) From: =?iso-8859-1?q?H=E9ctor=20Iturre?= Subject: Performance Problems To: LISTA DE POSTGRES MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/152 X-Sequence-Number: 10740 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