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

From Jonathan Corbet
Subject Re: Report: Linux huge pages with Postgres
Date
Msg-id 20101129083053.6ca281b9@bike.lwn.net
Whole thread Raw
In response to Report: Linux huge pages with Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Report: Linux huge pages with Postgres
Re: Report: Linux huge pages with Postgres
List pgsql-hackers
On Sat, 27 Nov 2010 14:27:12 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> And the bottom line is: if there's any performance benefit at all,
> it's on the order of 1%.  The best result I got was about 3200 TPS
> with hugepages, and about 3160 without.  The noise in these numbers
> is more than 1% though.
> 
> This is discouraging; it certainly doesn't make me want to expend the
> effort to develop a production patch.  However, perhaps someone else
> can try to show a greater benefit under some other test conditions.

Just a quick note: I can't hazard a guess as to why you're not getting
better results than you are, but I *can* say that putting together a
production-quality patch may not be worth your effort regardless.  There
is a nice "transparent hugepages" patch set out there which makes
hugepages "just happen" when it seems to make sense and the system can
support it.  It eliminates the need for all administrative fiddling and
for any support at the application level.

This patch is invasive and has proved to be hard to merge.  RHEL6 has it,
though, and I believe it will get in eventually.  I can point you at the
developer involved if you'd like to experiment with this feature and see
what it can do for you.

jon

Jonathan Corbet / LWN.net / corbet@lwn.net


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg_execute_from_file review
Next
From: Tom Lane
Date:
Subject: Re: Report: Linux huge pages with Postgres