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(at)postgresql(dot)org [mailto:pgsql-performance-
> owner(at)postgresql(dot)org] On Behalf Of Pavy Philippe
> Sent: den 25 mars 2014 9:10
> To: Matthew Spilich; pgsql-performance(at)postgresql(dot)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
>