pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alexander Lakhin <exclusion@gmail.com>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Aleksander Alekseev <aleksander@timescale.com>
Cc: Tomas Vondra <tomas@vondra.me>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: strange perf regression with data checksums
Date: Mon, 9 Jun 2025 09:00:00 +0300
Message-ID: <545be1e5-3786-439a-9257-a90d30f8b849@gmail.com> (raw)
In-Reply-To: <CAH2-WznZBhWqDBDVGh1VhVBLgLqaYHEkPhmVV7mJCr1Y3ZQhQQ@mail.gmail.com>
References: <941f0190-e3c6-4622-9ac7-c04e936e5fdb@vondra.me>
	<CAH2-Wzk-Dg5XWs_jDuiHt4_7ryrSY+n=vxmHY51EVqPDFsKXmg@mail.gmail.com>
	<CAH2-Wzk5NK09CsBD3teU1aK7obGnANfgwQgmFWR4yCf95xDKMg@mail.gmail.com>
	<d2fce2e6-720a-406a-aad6-1171c41260a3@vondra.me>
	<CAH2-WzkB9UTS2LLswbMQ3hByONiwRszbncneyVb_4PcWmmzR3Q@mail.gmail.com>
	<CAH2-Wzku139FB465_tukpi1gjHzsddEr0ZNA8zf1TexoFU1k6A@mail.gmail.com>
	<51332170-5a27-4482-ba13-48d13e5582f2@vondra.me>
	<CAH2-Wz=3-4srTde8WETyBVPjAL+i4PJ_oWj+Q3FkakkbHaHKsw@mail.gmail.com>
	<115a9164-5d91-4b5a-930a-3903bbb802fe@vondra.me>
	<CAH2-WzmAfk+f9ie9PmbeWFhXea0T41s-gJy1HULncYjOP+_5Uw@mail.gmail.com>
	<CAH2-WzmNWnuooD6tTdtDygeXVAGPtE=6j_ityTtOL_o7RzFzxA@mail.gmail.com>
	<bd8d04ec-11f9-443c-b431-c3f65ab04b96@vondra.me>
	<1a5b4b3c-7fe7-45c6-ae27-7129cd85ce5c@vondra.me>
	<CAH2-WznUWysOeHEZ7YnQrZDbWzaF=+gnn+-vi5bvK3Dnxj-g6Q@mail.gmail.com>
	<CAH2-Wzkfc70F0_2DxiepMUNLEDnnw-+-hYUVmpzGyJ6w+JnwxA@mail.gmail.com>
	<CAH2-WznZBhWqDBDVGh1VhVBLgLqaYHEkPhmVV7mJCr1Y3ZQhQQ@mail.gmail.com>

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

view thread (32+ messages)  latest in thread

Message-ID: <545be1e5-3786-439a-9257-a90d30f8b849@gmail.com>
Permalink:  ../545be1e5-3786-439a-9257-a90d30f8b849@gmail.com/
Also on:    postgresql.org/message-id/545be1e5-3786-439a-9257-a90d30f8b849@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: exclusion@gmail.com, pg@bowt.ie, aleksander@timescale.com, tomas@vondra.me
  Subject: Re: strange perf regression with data checksums
  In-Reply-To: <545be1e5-3786-439a-9257-a90d30f8b849@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox