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

Re: [PERFORM] Indexes on ramdisk

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

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-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 RAID

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 hav