Issues with blocksize smaller than 8KB

Поиск
Список
Период
Сортировка
От Casey Shobe
Тема Issues with blocksize smaller than 8KB
Дата
Msg-id C5DC82D6-C76D-4E8F-BC2E-DF03EFC4FA24@icloud.com
обсуждение исходный текст
Ответы Re: Issues with blocksize smaller than 8KB
Список 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 по дате отправления: