Обсуждение: [HACKERS] Huge pages support on Windows
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?
Hello, Andrea From: pgsql-hackers-owner@postgresql.org > [mailto:pgsql-hackers-owner@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.gzfrom 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