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  (Vivek Khera <vivek@khera.org>)
Список 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 по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: getting count for a specific querry
Следующее
От: Bob Henkel
Дата:
Сообщение: Re: getting count for a specific querry