Compiling PostgreSQL for WIndows with 16kb blocksize

Yannick Collette <yannickcollette@gmail.com> writes:

For test purposes I need to compile PostgreSQL 14.1 using a 16kb blocksize.

CFLAGS="-D WINVER=0x0600 -D _WIN32_WINNT=0x0600" LIBS="-ladvapi32"
./configure --host=x86_64-w64-mingw32 --with-blocksize=16
--with-wal-blocksize=16 --with-openssl --with-libxml
--prefix=/c/postgresql/pg14/ 2>&1 | tee configure.log

I don't know anything about the Windows-specific details here,
but the --with-blocksize option looks fine, and it works for me:

regression=# show block_size;
block_size
------------
16384
(1 row)

(Worth noting here is that a lot of our regression tests fail
at non-default blocksizes, because plans change, or rows no
longer need toasting, or the like.)

Unfortunately my blocksize is still 8kb when checking in DB.
postgres=# show block_size;
block_size
------------
8192
(1 row)

I think you must be connecting to the wrong server.

regards, tom lane

Hi,

On January 19, 2022 9:07:50 AM PST, Yannick Collette <yannickcollette@gmail.com> wrote:

Hello,

For test purposes I need to compile PostgreSQL 14.1 using a 16kb blocksize.

CFLAGS="-D WINVER=0x0600 -D _WIN32_WINNT=0x0600" LIBS="-ladvapi32"
./configure --host=x86_64-w64-mingw32 --with-blocksize=16
--with-wal-blocksize=16 --with-openssl --with-libxml
--prefix=/c/postgresql/pg14/ 2>&1 | tee configure.log

Below is the beginning of my configure.log, with no errors: make and make
install ok also.

configure: loading site script /etc/config.site
checking build system type... x86_64-pc-msys
checking host system type... x86_64-w64-mingw32
checking which template to use... win32
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 16kB
checking for segment size... 1GB
checking for WAL block size... 16kB
checking for x86_64-w64-mingw32-gcc... x86_64-w64-mingw32-gcc
checking whether the C compiler works... yes
...

DB created successfully using initdb.

Unfortunately my blocksize is still 8kb when checking in DB.

postgres=# show block_size;
block_size
------------
8192
(1 row)

postgres=# select version();
version
-----------------------------------------------------------------------------------------------------------------------------
PostgreSQL 14.1 on x86_64-w64-mingw32, compiled by
x86_64-w64-mingw32-gcc.exe (Rev9, Built by MSYS2 project) 10.2.0, 64-bit
(1 row)

Is there anything additional step I'm missing?

Any chance this is from an older build? You might need to make clean, if you previously ./configured differently.

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.