Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vA7Wh-00EHzb-HD for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Oct 2025 14:03:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vA7Vh-007r5X-Eq for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Oct 2025 14:02:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9may-003Mra-QA for pgsql-bugs@lists.postgresql.org; Fri, 17 Oct 2025 15:42:19 +0000 Received: from p-east1-cluster3-host7-snip4-2.eps.apple.com ([57.103.91.193] helo=outbound.ci.icloud.com) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v9mav-002JC1-2b for pgsql-bugs@lists.postgresql.org; Fri, 17 Oct 2025 15:42:18 +0000 Received: from outbound.ci.icloud.com (unknown [127.0.0.2]) by p00-icloudmta-asmtp-us-central-1k-60-percent-1 (Postfix) with ESMTPS id 2AC2A1801A24 for ; Fri, 17 Oct 2025 15:42:13 +0000 (UTC) Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=1a1hai; bh=ksiaEWd1r3VOKVOLtB3KZ/Obx50A6A8yfkS968X/o3s=; h=From:Content-Type:Mime-Version:Subject:Message-Id:Date:To:x-icloud-hme; b=TBVwGJ5KI4u1ORPzgAQ/xfs2mEubFLjEeUXWw1GTcwDvCcyT3+BRRji9WOFNatzuthuN0pdphyc3HT55S+eqQTV6MMtETwv70vsGHu+TrRQarAxv2Mib10+c7Va6U3TUW8bUpXrOXpEc4da+ci869IGiJ76rKT3W/aj+3ja3xn4lMnJhY76RsvWsbpb3KJpwTMimCku/MtBn7WzGwv20jKPDElb9TQajOyVXcspTMJXIDqnvuq/NkSFLLUTyaR1VSneIR6PyhqDcYQV+lcL//KcuSKepgUtr4pX0h+xWXb4FLBZraudM1qbUkIFAMgi+eaE6szlfMwluZO+DqmsRLA== Received: from smtpclient.apple (unknown [17.57.156.36]) by p00-icloudmta-asmtp-us-central-1k-60-percent-1 (Postfix) with ESMTPSA id 4136F1801A2B for ; Fri, 17 Oct 2025 15:42:13 +0000 (UTC) From: Casey Shobe Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.100.1.1.5\)) Subject: Issues with blocksize smaller than 8KB Message-Id: Date: Fri, 17 Oct 2025 11:42:12 -0400 To: pgsql-bugs@lists.postgresql.org X-Mailer: Apple Mail (2.3864.100.1.1.5) X-Proofpoint-Spam-Details-Enc: AW1haW4tMjUxMDE3MDExNiBTYWx0ZWRfX1UvS2xOCDOGb v01PucZWnFrHlEA5BJ207O3D/+RnW198vBik0FWJsH02ZfidryNxM+KK5K0zllGG3HEI1e5iABp qKhk9GkbFVWKYroF9mnmhNQmyMY60FoWo8NhxofdYNg8Nykm1+caD7/1682ivoJfebJZOMOlwxr ebEM719kYmgtT0mS5CPvD6szICzhTtxrGA7FrJDjz7XHllHKRGf2vSrpKbhz8AhQSdO08NBnv0T kxxCqtkWOGNCmxu2kfdqnQ3CrHAJuAPgpNtsQ8gHUAOmZIs0I5HOJyG3li/uHNqSEScjBJti0= X-Proofpoint-GUID: PqSBEOf_tObf89bCj1njYEi7QnJTelfi X-Proofpoint-ORIG-GUID: PqSBEOf_tObf89bCj1njYEi7QnJTelfi X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1121,Hydra:6.1.9,FMLib:17.12.80.40 definitions=2025-10-17_05,2025-10-13_01,2025-03-28_01 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 mlxlogscore=905 bulkscore=0 mlxscore=0 spamscore=0 phishscore=0 adultscore=0 suspectscore=0 malwarescore=0 clxscore=1011 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.22.0-2506270000 definitions=main-2510170116 X-JNJ: AAAAAAABrXHp/f4znqRuW7J4dlitEvoKu3OF3OhmgJF91dt88GJ+IMRGlSN331/y8U04wjweLZG0Il5CW7cdtpU22O+ORQysy4OlAV6QiT79vwM9SJ3P2yuFj7jNyo2M1+ZsX0vgpzzxrPrzXSsC3o7ZXFSwpGvCKi54z/TnnfIZIL2NnVIMtf035/+1Yf+5tp7mRdapi+jxeKeWsg8I4vXe1qtNYYMbf2RPB3/zVnwx5//3sim2Dxsxz0hycSopLn1y4mwG8aX9uDfLHFh4vEbLdtSkICwYSv1C8/gyk7DQCeF5Ci4JnLGDXQy2HsLLqrwekHXG6DLGFeAOg5hjWSAuKDt+XXoVk8zgOzxu6FFV383RLOlEVwzgj89An/i+Pp+c6r4yThN7Sx8W9i5XPVa2YLcFbEltEW6PUYH2s0fv5sWFpdMV/5bCj8/72d429hXrhfxl36DiVfERrBMVvqGAhAXWZ26sPCswq28b/z9Jbh91fAgLeLH/NJL/QtPa4Eso+NN4GLbbpb6MrjtEBwMROrcyGK5p2JKDP7X7x9op54NZC62TcG8rOF31HFLbISnQZT6jsXpurUI/XLXW5wUfOvmTiP8/QpLhOlNa06feqciz9+nB7q0hn7/mGhFsN5AE6kqeRJt7iajQeQvXcaPf List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I have been comparing performance of postgresql (18.0) compiled for = various block sizes etc., and found that while 8kb and 16kb builds work = fine, a 4kb build does not, with identical configuration. When I try to = initialize pgbench, --scale=3D10 works fine, but the --scale=3D100 I was = trying and even just --scale=3D20 result in a long delay on the vacuum = analyze step 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 server was 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=