Re: PG-related ACM Article: "The Pathologies of Big Data"

Поиск
Список
Период
Сортировка
От Pierre Frédéric Caillaud
Тема Re: PG-related ACM Article: "The Pathologies of Big Data"
Дата
Msg-id op.uyb66kq6cke6l8@soyouz
обсуждение исходный текст
Ответ на Re: PG-related ACM Article: "The Pathologies of Big Data"  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
>> I don't see how on any recent hardware, random access to RAM is slower
>> than
>> sequential from disk.  RAM access, random or not, is measured in
>> GB/sec...
>
> I don't think anybody's arguing that.

http://www.anandtech.com/cpuchipsets/showdoc.aspx?i=2795&p=5

These guys mention about 50 ns memory latency ; this would translate into
20 million memory "seeks" per second, which is in the same ballpark as the
numbers given by the article...

If you count 10GB/s bandwidth, 50 ns is the time to fetch 500 bytes.

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

Предыдущее
От: Fizu
Дата:
Сообщение: ORDER BY ... LIMIT and JOIN
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance