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 1u0nCy-00804P-QN for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Apr 2025 20: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 1u0nCw-004A3J-1F for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Apr 2025 20:00:06 +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 1u0nCv-004A3B-OQ for pgsql-bugs@lists.postgresql.org; Fri, 04 Apr 2025 20:00:05 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u0nCu-002yUv-0D for pgsql-bugs@lists.postgresql.org; Fri, 04 Apr 2025 20:00:04 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-43ea40a6e98so20771875e9.1 for ; Fri, 04 Apr 2025 13:00:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743796803; x=1744401603; darn=lists.postgresql.org; h=content-transfer-encoding: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=0NH+QCVSyYGk8ivY+p4SDCuLBQ2s/rt2C0ims7h3wc8=; b=cLkSWcRCGVQk7EsVWi03RPrdnMBE9RjTzO/FzaAjuEJc46siwcYHpnb9Exfie5Ulh8 lij/E3OzPMAatbVTGBARrZgt6JZwZR+k70jtSmGVBXLvGj7+cf6VgLBl+l2WslZ/UjrD 9ybkEDfEPnEi6YqLhebXiFhUVuD3nvm9ELTV/D6wDMt2CwengLyX566EY5CHlZGyp+Rj Y+oJxuW6ZoLivq7wVT8jAp+ZiByuy0OHpmQF2InGkj0PIi2cnvgwJGKfKOVKA3P1q3Df xiNO8lZ8s4hVSFxf/FfnjfzY/eVyZNWK+43md6MIOOu4AwfYa9EvVnIvxQSzOaPWjsOm 1gAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743796803; x=1744401603; h=content-transfer-encoding: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=0NH+QCVSyYGk8ivY+p4SDCuLBQ2s/rt2C0ims7h3wc8=; b=vok6pbebxYkOVhpTXc54RSDEhi5ud3CZI9mqriaIh8ilWpFzj1KLEsXb2qB/pF2kRQ aF9SHuLqrjCH6IJg27AeyRJVF5vk31fqA/MGcVRAGR3liJjru5fv//4IS1EppeyI7K8T rMqHxsNXNz5jNRpOymXFnuLg71YLM8IoIY1u7HNQTO7bY9XQAyMxDZ0wgUknLLipJNoy +efsH2HOBM6l4iFrVlzV82RjeQD3HGvfgg/wnbNqWk0WUJq1lC5QHdBZPzI1Wex4mmWB xORxHqimtkXTr57sVBrwEKmNS8Zr1TJ3BS4mHXJ+0b4pt6r9hgPClOi1y6ALlqfZNCKO oM8A== X-Gm-Message-State: AOJu0YyHbcv9Q2xHWVZKptGOXzNYFMGH1gJvONrPpoReetDQI5eRhXSr e+ikMow9INGpo01b0RweDFeNORlaTaA0PpGXQRtQ8IjfbTxfZeIRyBdZug== X-Gm-Gg: ASbGncvlwAMPpHuomuYI1kludYGp35TPKpZV9kNepp7/xgRKBdjfiqRc7MQWr6FZzUG 96S0TtKNVAtWKM5rfcvd2KtuJSBQ0FDTWj5W/vOrSiTdm8BUOEUk1QNFq4PuxxJEdlUmYD3D1S6 Vibs4b3pl1iS7Gu/e3qZzAGSmYg/7VNiFPASO3B5HWv0LDow63+fS4e3qnU1kLxVyxqI7k4NdHE cIS+NrAHVDej/63EAleByGf7GM8+hec3SvgkFrRu+tCZbzANoYpAZ5t/IlIiRppdJpc9ygwg1xX LmJzjsyxjzjY2UeCLewSXI0PzltUM1ArayH+c1PEg8FlDfA= X-Google-Smtp-Source: AGHT+IHf9rye2CX8x+SGcO5KWYdDCAGqRYGKFAVkWn8SDQZEag1kg3lQqIM46fnh8lDiZSix9zvyhA== X-Received: by 2002:a05:600c:4fd6:b0:439:9e13:2dd7 with SMTP id 5b1f17b1804b1-43ee0613515mr7107915e9.2.1743796802651; Fri, 04 Apr 2025 13:00:02 -0700 (PDT) Received: from [192.168.0.50] ([89.149.68.176]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-39c302269a2sm5169965f8f.91.2025.04.04.13.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 04 Apr 2025 13:00:02 -0700 (PDT) Message-ID: <7e61e7b5-c887-45d7-a993-9cf4c0b1c2d0@gmail.com> Date: Fri, 4 Apr 2025 23:00:01 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #18396: Assert in gistFindCorrectParent() fails on inserting large tuples into gist index To: Heikki Linnakangas , Tender Wang Cc: pgsql-bugs@lists.postgresql.org References: <18396-03cac9beb2f7aac3@postgresql.org> <4af76123-c80a-4bd4-8674-47129093f227@iki.fi> Content-Language: en-US From: Alexander Lakhin In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Heikki and Tender Wang, 04.04.2025 14:04, Heikki Linnakangas wrote: > On 15/11/2024 11:10, Tender Wang wrote: >> >> I agree that it doesn't matter. If internal page split due to adjust key consistent with the key we're inserting. >> The 'retry_from_parent' flag can help us get corrent downlinkoffnum. > > Ok, thanks for checking! Committed. > Thank you for working on this! Best regards. Alexander