Re: Report: Linux huge pages with Postgres

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Report: Linux huge pages with Postgres
Дата
Msg-id 20101128194531.GB3796@svana.org
обсуждение исходный текст
Ответ на Re: Report: Linux huge pages with Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, Nov 28, 2010 at 02:32:04PM -0500, Tom Lane wrote:
> > Sure, but 4MB of memory is enough to require 1000 TLB entries, which is
> > more than enough to blow the TLB even on a Nehalem.
>
> That can't possibly be right.  I'm sure the chip designers have heard of
> programs using more than 4MB.

According to
http://www.realworldtech.com/page.cfm?ArticleID=RWT040208182719&p=8
on the Core 2 chip there wasn't even enough TLB to cover the entire
onboard cache. With Nehalem there are 2304 TLB entries on the chip,
which cover at least the whole onboard cache, but only just.

Memory access is expensive. I think if you got good statistics on how
much time your CPU is waiting for memory it'd be pretty depressing.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patriotism is when love of your own people comes first; nationalism,
> when hate for people other than your own comes first.
>                                       - Charles de Gaulle

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: profiling connection overhead
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Rethinking representation of sort/hash semantics in queries and plans