Re: [PERFORM] Indexes on ramdisk

2005-10-05 Thread Merlin Moncure
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

Re: [PERFORM] Indexes on ramdisk

2005-10-05 Thread Emil Briggs
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

Re: [PERFORM] Indexes on ramdisk

2005-10-04 Thread Alex Turner
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

Re: [PERFORM] Indexes on ramdisk

2005-10-04 Thread Emil Briggs
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