Issues with blocksize smaller than 8KB - Mailing list pgsql-bugs

From Casey Shobe
Subject Issues with blocksize smaller than 8KB
Date
Msg-id C5DC82D6-C76D-4E8F-BC2E-DF03EFC4FA24@icloud.com
Whole thread Raw
Responses Re: Issues with blocksize smaller than 8KB
List pgsql-bugs
I have been comparing performance of postgresql (18.0) compiled for various block sizes etc., and found that while 8kb
and16kb builds work fine, a 4kb build does not, with identical configuration.  When I try to initialize pgbench,
--scale=10works fine, but the --scale=100 I was trying and even just --scale=20 result in a long delay on the vacuum
analyzestep followed by Postgres crashing due to a segmentation fault. 

I also found that initdb fails when I compile for a blocksize of either 1KB or 2KB build:

2025-10-17 15:39:13.182 UTC [97433] DETAIL:  The database cluster was initialized with RELSEG_SIZE 1895825408, but the
serverwas compiled with RELSEG_SIZE 1895825408. 
2025-10-17 15:39:13.182 UTC [97433] HINT:  It looks like you need to recompile or initdb.

- Casey


pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: Segfault in RI UPDATE CASCADE on partitioned tables with LIKE+ATTACH child (attnum drift)
Next
From: Yuri Zamyatin
Date:
Subject: Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade