Re: Stalls on PGSemaphoreLock - Mailing list pgsql-performance

From Gudmundsson Martin (mg)
Subject Re: Stalls on PGSemaphoreLock
Date
Msg-id 2E5766F28426E547AF0A2A870FAE630D22EAC0@SEGOTNC5182-N2.vcn.ds.volvo.net
Whole thread Raw
In response to Re: Stalls on PGSemaphoreLock  (Pavy Philippe <Philippe.Pavy@worldline.com>)
List pgsql-performance
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
>



pgsql-performance by date:

Previous
From: Pavy Philippe
Date:
Subject: Re: Stalls on PGSemaphoreLock
Next
From: Dave Johansen
Date:
Subject: Partitions and prepared statements?