Re: Sorting Improvements for 8.4

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Sorting Improvements for 8.4
Дата
Msg-id Pine.GSO.4.64.0712192052360.9196@westnet.com
обсуждение исходный текст
Ответ на Re: Sorting Improvements for 8.4  ("Dann Corbit" <DCorbit@connx.com>)
Ответы Re: Sorting Improvements for 8.4  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
On Wed, 19 Dec 2007, Dann Corbit wrote:

> Benchmarking a single system will really only explain that system.
> Someone may have a disk farm with 2GB/Sec throughput
> But such a configuration is very unlikely.

If you believe comments like those at 
http://www.c0t0d0s0.org/archives/1792-Do-it-yourself-X4500.html it's 
possible to hit >2GB/s total to the 48 disks in one of the Sun X4500 
servers, which start at $24K.  May be unlikely to you, but I was reading 
there after I set one up last night, and that's a boring standard 
configuration for some Sun and Greenplum customers.

Also, that's today--by the time 8.4 is mainstream high-end machines will 
be even faster.  Wanna make a bet on how much disk throughput will be 
available as SSD disks go mainstream in the next two years?

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: Sorting Improvements for 8.4
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Sorting Improvements for 8.4