From: Emil Briggs <emil@baymountain.com>
To: pgsql-performance@postgresql.org
Subject: Re: Indexes on ramdisk
Date: Wed, 5 Oct 2005 19:46:24 -0400
Message-ID: <200510051946.24326.emil@baymountain.com> (raw)
In-Reply-To: <33c6269f0510050803w72097bb5v526a0126af876af4@mail.gmail.com>
References: <200510042109.01849.emil@baymountain.com>
<200510042341.23264.emil@baymountain.com>
<33c6269f0510050803w72097bb5v526a0126af876af4@mail.gmail.com>
> What kind of order of improvement do you need to see?
>
A lot since the load on the system is expected to increase by up to 100% over
the next 6 months.
> What period are these number for? Were they collected over 1 hour, 1 day, 1
> month?
>
I thought I mentioned that in the earlier post but it was from a 2 hour
period. It's a busy system.
> How much Cache do you have on the controller?
>
64Mbytes but I don't think that's an issue. As I mentioned in the first post
the table that is the bottleneck has indexes on 15 columns and is seeing a
lot of inserts, deletes and updates. The indexes are spread out over the 5
mirrors but it's still a couple of writes per mirror for each operation. I'm
going to order an SSD which should give us a lot more headroom than trying to
rearrange the RAID setup.
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: emil@baymountain.com
Subject: Re: Indexes on ramdisk
In-Reply-To: <200510051946.24326.emil@baymountain.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