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.96) (envelope-from ) id 1wPfqh-000wT2-1H for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 12:16:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wPfqd-007XNJ-2C for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 12:16:28 +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.96) (envelope-from ) id 1wPfqd-007XNA-13 for pgsql-hackers@lists.postgresql.org; Wed, 20 May 2026 12:16:28 +0000 Received: from mail-vs1-xe36.google.com ([2607:f8b0:4864:20::e36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wPfqb-00000000U8h-2Hk4 for pgsql-hackers@lists.postgresql.org; Wed, 20 May 2026 12:16:27 +0000 Received: by mail-vs1-xe36.google.com with SMTP id ada2fe7eead31-6312b8f8e47so1480402137.3 for ; Wed, 20 May 2026 05:16:26 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779279385; cv=none; d=google.com; s=arc-20240605; b=MCeRk+MokZfmekI8hdIUzxJMKRxN/vBmBaeyIe/hGdinnTge62hYVvxgC/elP6QaMg GIn2SvAenXHBxF0MIQgbGtcpPvDe9uM3cfYvP0RsLtNHSkwGJQ9/4YQsmvurzc47MD0w fspkX0OINnJOXVsAl8Ll5FMsOmMeFUp1xl4K+4nPdjwX8jxSghqFoekUCiNFoq6P3dbT N43b6kWGvK8TBQK30o7z63WAgPgH420hIOEx84IckvD9zR2gBkWKWGKVtXT/QvzwI9Cn 4ZSQNjUA/D+5xRROavcF33ZhBw2irTeu5Q9Tj9PxZl6ecK5NoubaeNlUCWTIO+IenK/9 2+tQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=663XzfODOv86+Z+1rGtWhq83+Yei7B6C5yFyjOWl/Dw=; fh=ujUBJ4tt2ucRDs19V5W/d1mt4gTjLADyZpMmyqcc+XA=; b=aPL60ufAQDKOOC15RM/EqOWZwRBj+KOw+EOm8mJlPn1sCL5kLNSu7yKR13IXWtot6S xwA63mZmPImD/6gwS69GA7tyD11luOCSCu+GJisjfwTJtaDqKZhXu3FWK0VRSf4zmt0I iNA7wAX0xuhQKjyhAQ7iyRpIDU3ENkyKXIGnAzntv+RZlmmgNimoG/o/XVdHfeYnz2Sm G4qXpZgYBjuqaE2KDIR0eKKDJbH1RFOHIHtBw2vewYHwo6w9OdfKPtJksUSIYgb7en27 s/bIbM0Tgrqs8Z8AevQ9FANfYrhLaEwtrv4YYQrMd89RQHpwGkD+S2erWmF+y3Sdelca +EiA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779279385; x=1779884185; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=663XzfODOv86+Z+1rGtWhq83+Yei7B6C5yFyjOWl/Dw=; b=F5vQbWfecNEF4FU/3xkelulltfVdHBfeji29fYqn9mwAiUEsZDUPVTcrkRZ8M0/cRj fGEGR0RzFqi+/4ngsUZnNQbQaGnCrx5WiMufSQZ262dCXdJvYmH7w3DDjxI2dE+G4nx7 Hg+jxbfx/tVWvqpfpQsZSWoYCP3Bfzx5qmtsJU6hbL+mJvF/csdP5kw/bky3VTB8pVSC xNDyaWdQm8j92T3wjTx+ygaKKtZ2T3dIzqIOd8nHKTDbjvk8CsUZeIfHyeXrgVy0ls1m nu3nUIjX3lQu73DNGe/35HJp0cKEDMwUAEcfDR9QEstwQRzPAASBWeXjLLryVj+SrqdJ mDyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779279385; x=1779884185; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=663XzfODOv86+Z+1rGtWhq83+Yei7B6C5yFyjOWl/Dw=; b=TVEBQeBKHkGseCqHT3u7+DF5Qp6S0NztOIyrtFIKHegcWa2cAi0KV9znxxCelpiqlk zJtxEJyHuebJEep77hn2+dZwCHUi7abpeZg0XWQElnC9r8EKil1w5gnC1jZwtko7S48E KqRZTAOX6FCOo3+fYeJ5pCSEbxnTsKGQhQUOm9WqELH5cCoLOy7BppIn+50sYZfFIBqZ UzCxYC4TmAmyfxSotfM/iW2w+twBg86Yg3wPHMul5PVgBAze5q4oOgX7zmXE3c7tDQKF PUxJS4pqBBVcR2SB7aCc/+ZmXBGfsYgE+TvZQPBV58whK3ttj65n8Fy8CsWhJ0GZ0gld k8qg== X-Gm-Message-State: AOJu0YxLyeoIvDPZcvVXxESytSiGy49/4LrogX74N2i9GvnWvmNXys9i THlVlxIAr04Z/VwLL/yJ3SSY/An19f2eDAm9Hu7e8wSwaJdL0IK5q5hHzxcvdJaVrIeYy/Ze8+x uyqpiIyNR7fPQksLDRRNLbHRfZgi70+g= X-Gm-Gg: Acq92OEXpFKeB6+n3dTyESn2RjL6FNTrN99U2ZfCm8QgtcKew9H9NbJp5LnptMuP4W/ m7BBF5oPRaGn1B5rfvQdTHQNONNcO3Vi0qJCWBITIElBHe3GiUe76uAEe5HXSGjSuoDx9f950Ev LvRDPjam8ximE5DLSBHC6SJSWVCmHp9mGerCCfzaITzPZFqnvajrFDvDskVOW9O29k7AH1qNfto MrtmodVRnGIdikc46E/gk3b0rXMNHUzeg8bixfThHS/tkUt+Dtk3rnprzVAfyiKxPNxp0E4l0mo kwNXaJX/66tcwG0tQQ== X-Received: by 2002:a05:6102:2921:b0:632:4af0:4133 with SMTP id ada2fe7eead31-63a3f391c51mr10592336137.18.1779279385346; Wed, 20 May 2026 05:16:25 -0700 (PDT) MIME-Version: 1.0 References: <67115399-4799-4c3b-bd17-d43c98099919@vondra.me> <202508051121.fy6nhwsd4l26@alvherre.pgsql> In-Reply-To: From: solai v Date: Wed, 20 May 2026 17:45:46 +0530 X-Gm-Features: AVHnY4JFTto7LW3GmsV00IM1Qd6h7e7DTtcCNKyVkXQWDEuyYKJpp_x-RP-cyqg Message-ID: Subject: Re: amcheck support for BRIN indexes To: Arseniy Mukhin Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk The patch applied successfully, and the build completed without issues. I verified that brin_index_check() is not available on an unpatched build,and after applying the patch and updating the amcheck extension to version 1.6 ,the function worked as expected. I also ran some basic BRIN index validation tests successfully. One small thing I noticed during testing :after installing the patched build,I needed to run ALTER EXTENSION amcheck UPDATE before brin_index_check() became available. Regards, Solai