|From:||"Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>|
|To:||'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>|
|Cc:||Magnus Hagander <magnus(at)hagander(dot)net>, Robert Haas<robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org"<pgsql-hackers(at)postgresql(dot)org>|
|Subject:||Re: Supporting huge pages on Windows|
|Views:||Raw Message | Whole Thread | Download mbox|
From: Amit Kapila [mailto:amit(dot)kapila16(at)gmail(dot)com]
> Hmm. It doesn't work even on a command prompt with administrative
> privileges. It gives below error:
> waiting for server to start....2017-01-17 11:20:13.780 IST  FATAL:
> could not create shared memory segment: error code 1450
> 2017-01-17 11:20:13.780 IST  DETAIL: Failed system call was
> CreateFileMap ping(size=148897792,
> 2017-01-17 11:20:13.780 IST  LOG: database system is shut down
> stopped waiting
> pg_ctl: could not start server
> Examine the log output.
> Now, error code 1450 can occur due to insufficient system resources, so
> I have tried by increasing the size of shared memory (higher value of
> shared_buffers) without your patch and it works. This indicates some
> problem with the patch.
Hmm, the large-page requires contiguous memory for each page, so this error could occur on a long-running system where the memory is heavily fragmented. For example, please see the following page and check the memory with RAMMap program referred there.
BTW, is your OS or PostgreSQL 32-bit?
> > It seems that Windows removes many privileges, including "Lock Pages
> in Memory", when starting the normal command prompt. As its evidence, you
> can use the attached priv.c to see what privileges are assigned and and
> enabled/disabled. Build it like "cl priv.c" and just run priv.exe on each
> command prompt. Those runs show different privileges.
> This is bad.
> > Should I need to do something, e.g. explain in the document that the user
> should use the command prompt with administrative privileges when he uses
> I think it is better to document in some way if we decide to go-ahead with
> the patch.
Sure, I added these sentences.
+ To start the database server on the command prompt as a standalone process,
+ not as a Windows service, run the command prompt as an administrator or
+ disable the User Access Control (UAC). When the UAC is enabled, the normal
+ command prompt revokes the user right Lock Pages in Memory.
|Next Message||Haribabu Kommi||2017-01-30 02:20:30||Re: pg_hba_file_settings view patch|
|Previous Message||vinayak||2017-01-30 01:20:27||Re: Transactions involving multiple postgres foreign servers|