Re: Waiting on ExclusiveLock on extension

From: Andomar <andomar(at)aule(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Waiting on ExclusiveLock on extension
Date: 2015-04-20 20:41:58
Message-ID: 55356496.9060607@aule.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Another update (let me know if I'm mailing too much).

> 59.73% postmaster [kernel.kallsyms] [k]
> compaction_alloc

The compaction_alloc function seemed to point to issues with transparent
huge pages (THP.) I tried to turn this off with:

echo never > /sys/kernel/mm/transparent_hugepage/enabled

This change yielded immediate results. The "migration/xx" processes
disappeared from "top", the function "compaction_alloc" disappeared from
"perf top", and system load dropped from 5 to 0.3.

We've called off the 9.4 -> 9.3 downgrade for now.
For anyone else finding this thread, we are running CentOS 6.5 with
kernel 2.6.32 (which was released in Dec 2009.)

Cheers,
Andomar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-04-20 21:41:09 Re: Running pg_upgrade under Debian
Previous Message Dennis 2015-04-20 20:21:53 Re: monitoring bdr nodes