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.
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(at)svana(dot)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
In response to
pgsql-hackers by date
|Next:||From: Dimitri Fontaine||Date: 2010-11-28 20:02:56|
|Subject: Re: Rethinking representation of sort/hash semantics in queries and plans|
|Previous:||From: Robert Haas||Date: 2010-11-28 19:38:07|
|Subject: Re: profiling connection overhead|