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

["STERBECQ Didier" <didier.sterbecq@xxxxxxx>]

Title: Message

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.sterbecq@xxxxxxx

 

 -----Message d'origine-----
De : Boszormenyi Zoltan [mailto:zb@xxxxxxxxxxx]
Envoyé : mercredi 2 mai 2012 11:57
À : STERBECQ Didier
Cc : pgsql-general@xxxxxxxxxxxxxx
Objet : Re: 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.sterbecq@xxxxxxx

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/