> 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.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
