SUSE Manager/PostgreSQL thp

From MicroFocusInternationalWiki
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.