From: Héctor Iturre <hhiturre@yahoo.com.ar>
To: LISTA DE POSTGRES <pgsql-sql@postgresql.org>
Subject: Performance Problems
Date: Thu, 12 Dec 2002 09:56:15 -0300 (ART)
Message-ID: <20021212125615.23571.qmail@web20108.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hhiturre@yahoo.com.ar
Subject: Re: Performance Problems
In-Reply-To: <20021212125615.23571.qmail@web20108.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox