From: PFC <lists@peufeu.com>
To: Matthew <matthew@flymine.org>
To: pgsql-performance@postgresql.org
Subject: Re: 1-/2-dimensional indexes for common columns, rationale?
Date: Wed, 26 Mar 2008 17:24:46 +0100
Message-ID: <op.t8ms7kp2cigqcu@apollo13.peufeu.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0803261510290.20402@aragorn.flymine.org>
References: <47EA5B4D.5000300@geizhals.at>
<20080326150208.GH27264@a-kretschmer.de>
<Pine.LNX.4.64.0803261510290.20402@aragorn.flymine.org>
>>> create index foo1 on bla (a);
>>> create index foo2 on bla (b);
>>> create index foo3 on bla (a,b);
You say you need faster INSERT performance. Getting rid of some indexes
is a way, but can you tell a bit more about your hardware setup ?
For instance, if you only have one HDD, put an extra HDD in the machine,
and put the database on it, but leave the pg_xlog on the OS's disk. Or the
reverse, depending on which disk is faster, and other factors. Since heavy
INSERTs mean heavy log writing traffic, this almost doubles your write
bandwidth for the cost of a disk. Cheap and efficient. You can also put
the indexes on a third disk, but separating database and log on 2 disks
will give you the most benefits.
If you already have a monster hardware setup, though...
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-performance@postgresql.org
Cc: lists@peufeu.com, matthew@flymine.org
Subject: Re: 1-/2-dimensional indexes for common columns, rationale?
In-Reply-To: <op.t8ms7kp2cigqcu@apollo13.peufeu.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