Re: Report: Linux huge pages with Postgres - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Report: Linux huge pages with Postgres
Date
Msg-id 8866.1290972724@sss.pgh.pa.us
Whole thread Raw
In response to Re: Report: Linux huge pages with Postgres  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Report: Linux huge pages with Postgres
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Sun, 2010-11-28 at 12:04 -0500, Tom Lane wrote:
>> There's no exposed API for causing a process's regular memory to become
>> hugepages.

> We could make all the palloc stuff into shared memory also ("private"
> shared memory that is). We're not likely to run out of 64-bit memory
> addresses any time soon.

Mph.  It's still not going to work well enough to be useful, because the
kernel design for hugepages assumes a pretty static number of them.
That maps well to our use of shared memory, not at all well to process
local memory.

> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Report: Linux huge pages with Postgres
Next
From: Robert Haas
Date:
Subject: Re: profiling connection overhead