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 1uOVYG-004yqO-CN for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Jun 2025 06:00:08 +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 1uOVYE-005sGH-Ao for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Jun 2025 06:00:06 +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 1uOVYD-005sG9-W4 for pgsql-hackers@lists.postgresql.org; Mon, 09 Jun 2025 06:00:06 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uOVYC-0010BH-2j for pgsql-hackers@postgresql.org; Mon, 09 Jun 2025 06:00:06 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-450cf2291bbso13406005e9.0 for ; Sun, 08 Jun 2025 23:00:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749448802; x=1750053602; darn=postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=eb0ibH9qP63u8GY9lAY8sWQvLGIBET4ricgY9LOaFZ0=; b=nY+VSoUvCCxcYnKZ8qu/XOaaalHIxoWNb9JPOhLk5QxdIES3gqQgGxgDKs2eaXVGbo E5NGPfFcjawhvnb804oDQUBaqs4KOhBYrv1vueisqht5ltYKC4dznTGhQg6MHrgDniun b7WPvkZBPMUrExHBwgsL9gAKc8EE87Yqrnok+hPNAlZJpBlaq4GxeAxntgF2YvXDIO9q gWeyrHJgrkgB/lWwSq2wMrBSSNMwXFTiez3IOYukdzxX6CM7tL7RHSTmUefMbMA8BBnU TanFU1uC9ceAMron/uo76KrNszDFCf/f7yvY5TZHlOuZyeJzoUToaUO8uNh8L6yWWzjy d8CQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749448802; x=1750053602; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=eb0ibH9qP63u8GY9lAY8sWQvLGIBET4ricgY9LOaFZ0=; b=n2R4K0mFDYlSRNYmHsw8rCC2eJ8PoxRlMEy6YLW+qRQXAOEUw0veW0C6iqFF26Lrre km90NR99U7lJBoRVA/qHRsyC+ED55YyR781AJNrLZW9zeXiuoE7PZVeiguE+ObO8wtUT jBNzwqhs1XRjfDd7fdxx71vsMXmxiXu/sptIrOrI9A6SjkaDftKQ6xy3CSBUb0unTHmc kFiRf4Vtx7Kew8ECmQMDmiSSZ8ZSt7pz8PE78gIvIa0MNJD1pSIrJ30NsOrc0seI8I+k niHUsLRBumZ0RvXoWgMYQmp3VEt0ryC92c93WgvP5ygylFwgqYBO73M6rTkvPkd8SwWP fYVw== X-Forwarded-Encrypted: i=1; AJvYcCWc+hl7pTjLip8L0PiwNLLVWfk+6YR2IWMFiW/2UUNEvuKsF4GJHBU/GBWvvtv2skIc804fcGYQa2Q9NRHP@postgresql.org X-Gm-Message-State: AOJu0YzujRknyRY+Xqg9aIyNyUqiEW0fWl0P3ISN59YPUXEZ5pjCLjK1 mmbWMUqzFDtQj0aEe/8otPilAkrZAxgjxoncyl6nO5/WTI0/XcKWDJQk X-Gm-Gg: ASbGncvpCT1bdi9Vei8US8iH8+Ej3C8djLjIUqiAzhxvZwhQA5mW4/O5NMNG4Ltoi5C kMPft7JjGISwF92YkMZDUErsqWzCLvaBegwIKxzS5J1tEbjF3JftDmEfrAwhmCtNq6Ygvf+aKUv 2enC+0ZPN1Qnb/jKj6F8ZrGc24dNae49oEG2lc4E+gHPqnyloBbLTfLHBf2u4b9JjpMcXYqbm+/ fGQv4S+Td+lmOeTHAhhVBmTLptXB8B85Z0KMvoAWkNvWiRMFQBGsdWJTmcexG7pOmmsDRsuG2uz HOqL8vPDcH5JpWDKYLafzBRgLP2U7HCU5FCZkrhyVtcetIgfhY4jR1ds+s3kpcA5aA== X-Google-Smtp-Source: AGHT+IET6LorbIvJaBWxJ+zZREDZyNkEsqz3RvI7YleZK1xzUzs5EDauDcnfHZf8bx6B4pGP+m8G+g== X-Received: by 2002:a05:600c:4e09:b0:442:c993:6f94 with SMTP id 5b1f17b1804b1-452013510famr111821245e9.12.1749448802013; Sun, 08 Jun 2025 23:00:02 -0700 (PDT) Received: from [192.168.0.50] ([89.149.120.224]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-452730c747dsm99934955e9.31.2025.06.08.23.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 08 Jun 2025 23:00:01 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------VbemCVcM1NZDcC9IQKb0femW" Message-ID: <545be1e5-3786-439a-9257-a90d30f8b849@gmail.com> Date: Mon, 9 Jun 2025 09:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: strange perf regression with data checksums To: Peter Geoghegan Cc: Aleksander Alekseev , Tomas Vondra , PostgreSQL Hackers References: <941f0190-e3c6-4622-9ac7-c04e936e5fdb@vondra.me> <51332170-5a27-4482-ba13-48d13e5582f2@vondra.me> <115a9164-5d91-4b5a-930a-3903bbb802fe@vondra.me> <1a5b4b3c-7fe7-45c6-ae27-7129cd85ce5c@vondra.me> Content-Language: en-US From: Alexander Lakhin In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------VbemCVcM1NZDcC9IQKb0femW Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hello Peter, 06.06.2025 19:33, Peter Geoghegan wrote: > On Wed, Jun 4, 2025 at 1:39 PM Peter Geoghegan wrote: >> My current plan is to commit this in the next couple of days. > Pushed. Please look at the following script, which falsifies an assertion introduced with e6eed40e4: create user u; grant all on schema public to u; set session authorization u; create table tbl1 (a int); create function f1() returns int language plpgsql as $$ invalid $$; select sum(1) over (partition by 1 order by objid)   from pg_shdepend   left join pg_stat_sys_indexes on refclassid = relid   left join tbl1 on true limit 1; (I've simplified an assert-triggering query generated by SQLsmith.) TRAP: failed Assert("!BTScanPosIsPinned(so->currPos)"), File: "nbtutils.c", Line: 3379, PID: 1621028 ExceptionalCondition at assert.c:52:13 _bt_killitems at nbtutils.c:3380:3 _bt_steppage at nbtsearch.c:2134:5 _bt_next at nbtsearch.c:1560:7 btgettuple at nbtree.c:276:6 index_getnext_tid at indexam.c:640:25 index_getnext_slot at indexam.c:729:10 IndexNext at nodeIndexscan.c:131:9 ExecScanFetch at execScan.h:126:10 ... Best regards, Alexander --------------VbemCVcM1NZDcC9IQKb0femW Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Hello Peter,

06.06.2025 19:33, Peter Geoghegan wrote:
On Wed, Jun 4, 2025 at 1:39 PM Peter Geoghegan <pg@bowt.ie> wrote:

My current plan is to commit this in the next couple of days.

Pushed.

Please look at the following script, which falsifies an assertion
introduced with e6eed40e4:
create user u;
grant all on schema public to u;
set session authorization u;
create table tbl1 (a int);
create function f1() returns int language plpgsql as $$ invalid $$;

select sum(1) over (partition by 1 order by objid)
  from pg_shdepend
  left join pg_stat_sys_indexes on refclassid = relid
  left join tbl1 on true
limit 1;
(I've simplified an assert-triggering query generated by SQLsmith.)

TRAP: failed Assert("!BTScanPosIsPinned(so->currPos)"), File: "nbtutils.c", Line: 3379, PID: 1621028
ExceptionalCondition at assert.c:52:13
_bt_killitems at nbtutils.c:3380:3
_bt_steppage at nbtsearch.c:2134:5
_bt_next at nbtsearch.c:1560:7
btgettuple at nbtree.c:276:6
index_getnext_tid at indexam.c:640:25
index_getnext_slot at indexam.c:729:10
IndexNext at nodeIndexscan.c:131:9
ExecScanFetch at execScan.h:126:10
...

Best regards,
Alexander
--------------VbemCVcM1NZDcC9IQKb0femW--