Re: One particular large database application

Поиск
Список
Период
Сортировка
От Lincoln Yeoh
Тема Re: One particular large database application
Дата
Msg-id 5.1.0.14.1.20020423190534.02fe6930@192.228.128.13
обсуждение исходный текст
Ответ на Re: One particular large database application  (Curt Sampson <cjs@cynic.net>)
Ответы Re: One particular large database application  (Curt Sampson <cjs@cynic.net>)
Список pgsql-general
AFAIK google uses thousands of pcs with IDE drives. So going the multiple
PC way can work.

Not sure how that would be implemented for postgresql. It seems simple to
support _many_ read only queries at a time using many pcs. But how would
one speed up a few large parallel queries that way?

Cheerio,
Link.

At 08:08 AM 4/23/02 +0900, Curt Sampson wrote:
>On Mon, 22 Apr 2002, Francisco Reyes wrote:
>
> > IDE's may have good thoughput, but their seek times can't compete with top
> > of the line SCSI.
>
>Dollar for dollar, IDE has far better performance. Even including the
>cost of extra controllers (because you need one controller for each
>drive), I can get four high-end IDE drives for the price of one SCSI
>drive. There's no way any SCSI drive is going to do as many I/Os per
>second as four good IDE drives.
>
>As well, seek time isn't always important. For your log disk, for
>example, you care more about high sequential write speed.
>
> > Exactly.. since it won't be easy for you to find the best distributions
> > then it may be worth getting better hardware. :-)
>
>What makes you think it won't be easy, in my case?
>
>cjs



В списке pgsql-general по дате отправления:

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: One particular large database application
Следующее
От: Curt Sampson
Дата:
Сообщение: Re: One particular large database application