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)
Список pgsql-performance
Дерево обсуждения
PG-related ACM Article: "The Pathologies of Big Data"  (Josh Kupershmidt, )
 Re: PG-related ACM Article: "The Pathologies of Big Data"  (Greg Stark, )
 Re: PG-related ACM Article: "The Pathologies of Big Data"  (Scott Marlowe, )
  Re: PG-related ACM Article: "The Pathologies of Big Data"  (Scott Marlowe, )
   Re: PG-related ACM Article: "The Pathologies of Big Data"  (Scott Carey, )
    Re: PG-related ACM Article: "The Pathologies of Big Data"  (Scott Marlowe, )
     Re: PG-related ACM Article: "The Pathologies of Big Data"  (Pierre Frédéric Caillaud<>, )
>> 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 по дате отправления:

Предыдущее
От: Pierre Frédéric Caillaud
Дата:
Сообщение: Re: PG-related ACM Article: "The Pathologies of Big Data"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance