RE : Postgres 8.x on Linux : how to use HugePages

Thanks Zoltan,

I try it on Kernel Linux 2.6.18 ( RedHat 5.2) 64 bits, it works.
I add that ulimit "memlock" (-l) had to be increased for the Postgres runner, up to the size of the shared memory required by Postgres.

Didier Sterbecq.
Mail : didier(dot)sterbecq(at)rapt(dot)fr

-----Message d'origine-----
De : Boszormenyi Zoltan [mailto:zb(at)cybertec(dot)at]
Envoyé : mercredi 2 mai 2012 11:57
À : STERBECQ Didier
Cc : pgsql-general(at)postgresql(dot)org
Objet : Re: [GENERAL] Postgres 8.x on Linux : how to use HugePages

Hi,

2012-05-02 11:28 keltezéssel, STERBECQ Didier írta:

We think of using Linux HugePages to isolate shared memory used by Postgres, hoping that we got more performance.

I see some souce code samples for doing that, but I do not see any information
about compatibility : Postgres 7.x, 8.x, 9.x
about recommandations

Thanks by advance.
Didier Sterbecq.
Mail : didier(dot)sterbecq(at)ratp(dot)fr

if you are using a kernel older than 2.6.38, you can use this with LD_PRELOAD:
http://oss.linbit.com/hugetlb/

With 2.6.38 and up, HugePages are used automatically in giant allocations.

Best regards,
Zoltán Böszörményi


--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/