> 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
What kind of order of improvement do you need to see?
What period are these number for? Were they collected over 1 hour, 1 day, 1 month?
How much Cache do you have on the controller?
You can certainly get more speed by adding more disk and possibly by
adding more controller RAM/a second control
> It's a quad opteron system. RAID controller is a 4 channel LSILogic
> Megaraid
> 320 connected to 10 15k 36.7G SCSI disks. The disks are configured in
5
> mirrored partitions. The pg_xlog is on one mirror and the data and
indexes
> are spread over the other 4 using tablespaces. These numbers from
> Talk about your IO system a bit. There might be obvious ways to improve.
>
> What System/Motherboard are you using?
> What Controller Cards are you using?
> What kind of Disks do you have (SATA, SCSI 7.6k 10k 15k)
> What denominations (9, 18, 36, 72, 143, 80, 160, 200 240Gig)?
> What kind of RAID
Talk about your IO system a bit. There might be obvious ways to improve.
What System/Motherboard are you using?
What Controller Cards are you using?
What kind of Disks do you have (SATA, SCSI 7.6k 10k 15k)
What denominations (9, 18, 36, 72, 143, 80, 160, 200 240Gig)?
What kind of RAIDs do you hav
I have an application that has a table that is both read and write intensive.
Data from iostat indicates that the write speed of the system is the factor
that is limiting performance. The table has around 20 columns and most of the
columns are indexed. The data and the indices for the table are
