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@xxxxxxxxxxxxxx [mailto:pgsql-performance- > owner@xxxxxxxxxxxxxx] On Behalf Of Pavy Philippe > Sent: den 25 mars 2014 9:10 > To: Matthew Spilich; pgsql-performance@xxxxxxxxxxxxxx > Subject: Re: 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 > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
