Thread: Postgres 8.x on Linux : how to use HugePages
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@ratp.fr
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@ratp.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/
De : Boszormenyi Zoltan [mailto:zb@cybertec.at]
Envoyé : mercredi 2 mai 2012 11:57
À : STERBECQ Didier
Cc : pgsql-general@postgresql.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.sterbecq@ratp.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/