Re: [HACKERS] Huge pages support on Windows

2017-06-15 Thread Tsunakawa, Takayuki
Hello, Andrea

From: pgsql-hackers-ow...@postgresql.org
> [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Andrea caldarone
> Anyone can point me in the right direction?

Thank you for your interest.

1. Download the PostgreSQL 10 source code (which is still in development), 
which is the file named postgresql-snapshot.tar.gz from here:

https://ftp.postgresql.org/pub/snapshot/dev/

2. Get the latest patch for huge page support for Windows in the mail thread 
you saw.  The file name is win_large_pages_v13.patch.

3. Decompress the source code and apply the patch.
$ tar zxf postgresql-snapshot.tar.gz
$ cd postgresql*
$ patch -p1 < win_large_pages_v13.patch

Now you can build and install the program normally.

Regards
Takayuki Tsunakawa


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] Huge pages support on Windows

2017-06-15 Thread Andrea caldarone
Hi all,

First of all bear with me since I'm new in PostgreSQL world, I'm SQL Server
DBA with 20yrs experience.
I've seen the thread started by Tsunakawa Takayuki about huge pages support
on windows and his version of pg_ctl.c in commit fest.
I see no information anywhere about how to recompile only the pg_ctl.exe in
Windows or how to apply a .patch file in Windows.
I've used Mingw64 to build the whole PostgreSQL from source code and I
succeded, then I tried to the pg_ctl.c in source files with the pg_ctl.exe
modified by Tsunakawa Takayuki, I've taken only the pg_ctl.exe generated
and put in my Windows machine, it works but when I try to enable huge pages
in the postresql.conf, the service fails to start with the message "CEST
FATAL:  huge pages not supported on this platform"

Anyone can point me in the right direction?