Re: Stalls on PGSemaphoreLock

Hi Pavy!
What kernel version/RHEL release are you running on the servers you are experiencing these issues?
I'm interested in knowing since I suspect similar issues on some of our database servers.

Best regards, Martin

> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Pavy Philippe
> Sent: den 25 mars 2014 9:10
> To: Matthew Spilich; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Stalls on PGSemaphoreLock
>
> Here, we were the transparent hugepage always actif:
>         cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
>         [always] never
>
> We changed to:
> cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
>         always [never]
>
>
>
> For the semaphore, our initial configuration was:
>         cat /proc/sys/kernel/sem
>         250 32000 32 128
>
> And we changed to:
>         cat /proc/sys/kernel/sem
>         5010    641280  5010    128
>