SUSE Manager/PostgreSQL thp
Transparent huge pages in PostgreSQL
Transparent huge page should NOT be enabled with PostgreSQL.
"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.