SUSE Manager/PostgreSQL thp

From MicroFocusInternationalWiki
Revision as of 15:43, 8 February 2016 by Kwk (Talk | contribs) (Created page with "SUSE Manager Main Page =Transparent huge pages in PostgreSQL= Transparent huge page should '''NOT''' be enabled with PostgreSQL. Taken from [")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SUSE Manager Main Page

Transparent huge pages in PostgreSQL

Transparent huge page should NOT be enabled with PostgreSQL.

Taken from PostgreSQL pain points on

"Another problem frequently experienced by PostgreSQL users is that recent kernel features tend to create performance problems. For example, the transparent huge pages feature tends not to bring much benefit to PostgreSQL workloads, but it slows them down significantly. Evidently a lot of time goes into the compaction code, which is working hard without actually producing a lot of free huge pages. In many systems, terrible performance problems simply vanish when transparent huge pages are turned off."

But there's also this report. So we might revise the situation at a later point in time.