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 1uhwGs-005ie2-Km for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Aug 2025 20:22:31 +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 1uhwGq-009IGk-Mo for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Aug 2025 20:22:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uhwGq-009IFK-Cw for pgsql-hackers@lists.postgresql.org; Fri, 01 Aug 2025 20:22:28 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uhwGo-000GSm-0L for pgsql-hackers@lists.postgresql.org; Fri, 01 Aug 2025 20:22:28 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-e8e22a585bdso1711132276.0 for ; Fri, 01 Aug 2025 13:22:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754079744; x=1754684544; darn=lists.postgresql.org; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=/HnaAefat6yjaJ1iBkdhMM9dMhdHYhCKnrzFms1pFm4=; b=eqU8DgXBiN7b4UqQ1IpdU+pu1GCmI2OaOXQrcEpySCV1DhFALvc05LYsPvybIAO+m2 j1NKK4UlAlVOcVcziMXJsNXVwiTk+YoiA4d2H+FMti/0McLkIQPENiGnNX1kX71Szftc Ws24APulRNz6PyZMAn/5yTiEj3y12AecmA9tKKhzQPjhuId3O5I3z5+t/TP7QpSA4EjP IRtrGS0Xwc9ZonW3wYORAzU4Fjc+OYaPL/CZA64xgSpqCdp1glJengpR4tErmZIYG/NA mHR4i4JEL83e7Mb/+w51TH92ONcNvwTkiHSFRfzcP7udGWNJs1unXZqXKdTbeE09bb56 8a7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754079744; x=1754684544; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=/HnaAefat6yjaJ1iBkdhMM9dMhdHYhCKnrzFms1pFm4=; b=fUTUld0b+KZpYGCAlQc38tJlCjZgGkPpDMEZw9oKKZK/ZBx8HOiINJW6/+pBF0HQDI sCsQRwAv/WHr3Yog1P0/qmh938l4wI9RAQN/s6n+GHYheK2ZWZI1xV/syv8TbgdstdSz kLqfkQUW5QVGsIPXjit/QVy/dUvD2ENzkb0LDPj2L6hn6dhqLSa+4FivIJkW1VAQ7Kyq MBwhidfNuhvf+kl5UuqQVh601CjlSgI2Vg2L5R/GoOyO5GtqUiKyc6K7nsEw+O2duSUP W8GfdI2mnzAHmqXSp/Uvzr6Zy2QwRq1zhB0I8V7ZLuE8PQGLg9almNSMksSjxekUkzAx wNCQ== X-Gm-Message-State: AOJu0YyYwwAfXMZ0nWaaPkt1AtgUhLHDu8QYS3i8eAm96kSWcRl6ajOR ajBS+8fW5ccRo8iqXAVI/OLeHbcIjiM1YfqdYTsGXH/Vr5ld9cZvAm2l3bmi1GvyJ+aYNp/QKF/ b2sWg4Je55VNu2vgydKmJ/PSmNmiVxCOeYGHVaXM= X-Gm-Gg: ASbGnctLMkY57UAPxXHylujRr8yEjs8DCMLiyfhzaPhNLuwELhl55yXV4JFRV2Eyx+Q SD8Psx7lwKtdPA4yf9ZkQIKJVtHCjHcZarTAYBgntxGV77FaNPgdvKfvvz+sqi+h4DONcG6srJZ Xj2Ko8pN3uP7rHLVcTdpDr5FQNsxzc/K7ftDzh/r7yd/JaQYQfNYTwZRmejG4haRiMSKZxOGnRF jxtapbFe4da8A0jkCU= X-Google-Smtp-Source: AGHT+IFks6HoXIy0UAvR6gyFAZwaHoKHrhwK+TV1OcOQBn9XyHC8oojF0qTWqMWUC33JGpjWpEXnfzzZHAirXq8Lw9I= X-Received: by 2002:a05:690c:9416:20b0:70e:2c7f:2ee7 with SMTP id 00721157ae682-71b7f5f31fdmr10507247b3.12.1754079744150; Fri, 01 Aug 2025 13:22:24 -0700 (PDT) MIME-Version: 1.0 References: <202507071221.am6rbd6n4dct@alvherre.pgsql> <67115399-4799-4c3b-bd17-d43c98099919@vondra.me> In-Reply-To: From: Arseniy Mukhin Date: Fri, 1 Aug 2025 23:22:13 +0300 X-Gm-Features: Ac12FXyYa9Xu_2xX5p39mqTY_Wkq8lF-5CxL48zHfmX86Pq2DnSIA_5PuAzbuNg Message-ID: Subject: Re: amcheck support for BRIN indexes To: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Tue, Jul 22, 2025 at 6:43=E2=80=AFPM Arseniy Mukhin wrote: > > Hi, > > While reviewing gist amcheck patch [1] I realized that brin amcheck > also must check if current snapshot is OK with index indcheckxmin (as > btree, gist do it). Currently this check is contained in btree amcheck > code, but other AMs need it for heapallindexed as well, so I moved it > from btree to verify_common (0003 patch). There was a compiler warning on CI, so there is a new version with the fix (adds #include to verify_common). I also moved it to PG19-2. Best regards, Arseniy Mukhin