From: Christoph Haller <ch@rodos.fzk.de>
To: hhiturre@yahoo.com.ar
Cc: pgsql-sql@postgresql.org
Subject: Re: Performance Problems
Date: Thu, 12 Dec 2002 15:29:45 +0100
Message-ID: <3DF89D59.DAD4BAC3@rodos.fzk.de> (raw)
>
> 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.
>
Bear in mind, every index has to be updated when records
are inserted. An unique one makes it even worse, because
a search for duplicates must be performed.
You may give the idea some thought, if this index really
has to be unique. I sometimes use a 'timestamp-insert'
column to allow duplicates and retrieve unique entries by
a SELECT DISTINCT ON construct.
Regards, Christoph
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: ch@rodos.fzk.de, hhiturre@yahoo.com.ar
Subject: Re: Performance Problems
In-Reply-To: <3DF89D59.DAD4BAC3@rodos.fzk.de>
* 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