Re: Problems with huge_pages and IBM Power8 - Mailing list pgsql-hackers

From reiner peterke
Subject Re: Problems with huge_pages and IBM Power8
Date
Msg-id 086723C3-E025-42A6-B452-CC45571FB1BD@drizzle.com
Whole thread Raw
In response to Re: Problems with huge_pages and IBM Power8  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> On Apr 12, 2016, at 10:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Andres Freund <andres@anarazel.de> writes:
>> On 2016-04-12 21:58:14 +0200, reiner peterke wrote:
>>> Looking for some insight into this issue.  the error from the postgres
>>> log on ubuntu is below.  It apperas to be related to semephores.
>
>> I've a bit of a hard time believing that this is related to huge pages.
>
> I'm betting that's this:
>
> http://www.postgresql.org/message-id/CAK7tEys9-O4BTERbs3Xuk2BfFNNd55u2sM9j5R2Fi7v6BHjrQw@mail.gmail.com
>
>             regards, tom lane

Hi Tom,

You appear to have been correct.  :-)
The being led to believe it was connected to huge_pages turns out to have been a coincidence since we had been working
withhuge_pages. 

Postgres happened to crash close enough to trying the huge_pages and did not appear to crash when they were disabled
ledus to make that conclusion. 

After a bit more careful testing we found out that postgres did indeed crash even without huge_pages.  The setting in
thelink appears to have resolved this issue. 

Thanks.

reiner




pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: SET ROLE and reserved roles
Next
From: Robert Haas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <