Re: getting count for a specific querry
От | Scott Marlowe |
---|---|
Тема | Re: getting count for a specific querry |
Дата | |
Msg-id | 1112992262.20921.81.camel@state.g2switchworks.com обсуждение исходный текст |
Ответ на | Re: getting count for a specific querry (Vivek Khera <vivek@khera.org>) |
Ответы |
Re: getting count for a specific querry
|
Список | pgsql-sql |
On Fri, 2005-04-08 at 15:23, Vivek Khera wrote: > On Apr 8, 2005, at 3:23 PM, Joel Fradkin wrote: > > > I set up the data on 4 10k scsi drives in a powervault and my wal on 2 > > 15k > > drives. I am using links to those from the install directory. It > > starts and > > stops ok this way, but maybe it should be different. > > > > Your problem might just be the choice of using a Dell RAID controller. > I have a 1 year old box connected to a 14 disk powervault (PowerEdge > 2650) and it is dog slow compared to a dual opteron with 8 disks that > is replacing it. It is all I/O for me, and the dell's just are not > known for speedy I/O. Note that there are several different RAID controllers you can get with a DELL. I had good luck with the PERC 4C (AMI MegaRAID based) at my last job. In a dual 2400Mz machine with 2 gigs ram, it handily outran a 4 way (about 1200 MHz CPUs) windows / MSSQL box with 4 gigs of ram at most tasks. Especially inserts / updates. The windows machine had the more generic PERC 3I type controller in it.
В списке pgsql-sql по дате отправления: