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 1rxOBP-008BoS-IZ for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Apr 2024 09:35:55 +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 1rxOBM-002kGm-JS for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Apr 2024 09:35:52 +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 1rxOBM-002kD1-8I for pgsql-hackers@lists.postgresql.org; Thu, 18 Apr 2024 09:35:52 +0000 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rxOBH-001bSH-Dq for pgsql-hackers@postgresql.org; Thu, 18 Apr 2024 09:35:50 +0000 Received: by mail-wm1-x330.google.com with SMTP id 5b1f17b1804b1-418c0d83d18so4774955e9.0 for ; Thu, 18 Apr 2024 02:35:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1713432945; x=1714037745; darn=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=aRCHCKPHrnhhu6EDRcN8hmMVNPUrI9g0VxotUB+M4nA=; b=ED/6Z5ehxzDH1BveLNBapBKrbIRBQxdtL8OHAPgpyTPwt/D6W39V7mFCe6R/M5Gtjq K7+Mo6MZQ6h47lQCDDFwCgm0LUKT5oaDIH6F0mJFqZU69Hhksp05suMSMEB5s40es/kZ sqUxsxGNVWJzKRUN+SYLvUJMfEqxPJX8a17cIhX4PGivbRnERgqibPtoAZ0gwBJGHvyq PgDloU+kWtiXJQTjsmGEYlyrejCaBwCaPvbjXdRi+SKGz9gfvisZYAu3y1aBei23QCC6 O31kbZXowmEwQchb5HJoE1Bmn7afhye/xANhS614a72UaqUNBqXGWR7Nepw6DqQ6Rf0b +WUw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713432945; x=1714037745; 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=aRCHCKPHrnhhu6EDRcN8hmMVNPUrI9g0VxotUB+M4nA=; b=n2p03j+tAU4cIUVRiD3GDLLku5HUPP8hBm3mccMNH9NMWEm9vFI7szmlqs+rkiPN1C 2pJZVgYzbb0qLZA5Vik5bvSgZzI1Ru4zmTFyHjPqXQz0yUp3dW3DlqmPVpGptCCLoAVR 7flMB+3O98RDgYN56irpJ+gBD6goH8LhJRe/GQzh79ZigP2NIRI/LAWfL0+S84B7aCWJ 6C+hQQhc3nnrpLTK27QjF+2NTt2QccJnWXMFJXE/89Vpr+CWJN5F5030xIf5rY5Lo0lL cfmNH/5ndiiFt9vcH3Oe9BrLJ4tuvBb01XQ+e2Ipt4POEZNV6OqxO7Eci/XhcfcH2qO1 kY5A== X-Forwarded-Encrypted: i=1; AJvYcCVR4lP2f59mEQPVrVQ10E1jIz5g2C8KM2cFOowvjVYik9L+1VhdCkI5FGtaVHptNX7C3WP8ZspHg5rHld+R+hRLMOUGMAjATWqS7Szp X-Gm-Message-State: AOJu0YxFDpKg3CNCMLQ2My4xNpxpKiMtLJOb3WnksuXTFAK1lw0pOyob bbtdvIEJ4XWyS1yoZ2xQTZU83+IHvJFI3C0rbmWYmn4HYWxTwKx9+Q3R30MAXQ== X-Google-Smtp-Source: AGHT+IGnow5fabRquRyaWxuvWl5WAyIIcb1JlBX+BOIOUND1g3jTDt2ZHskRtsrhK1LOdTCyhDdDeg== X-Received: by 2002:a5d:6481:0:b0:343:e46d:2801 with SMTP id o1-20020a5d6481000000b00343e46d2801mr1691751wri.51.1713432944780; Thu, 18 Apr 2024 02:35:44 -0700 (PDT) Received: from [10.137.0.18] (ip-86-49-229-30.bb.vodafone.cz. [86.49.229.30]) by smtp.gmail.com with ESMTPSA id p13-20020adfe60d000000b00349b73143e7sm1372580wrm.75.2024.04.18.02.35.44 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 18 Apr 2024 02:35:44 -0700 (PDT) Message-ID: <14e52b46-a802-4035-b33a-627968e14375@enterprisedb.com> Date: Thu, 18 Apr 2024 11:35:43 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: brininsert optimization opportunity To: Michael Paquier , Alvaro Herrera Cc: Alexander Lakhin , Soumyadeep Chakraborty , Matthias van de Meent , pgsql-hackers , Ashwin Agrawal References: <202402291220.gmjxa5wohzsh@alvherre.pgsql> Content-Language: en-US From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/18/24 09:07, Michael Paquier wrote: > On Thu, Feb 29, 2024 at 01:20:39PM +0100, Alvaro Herrera wrote: >> I think it's not an issue, or rather that we should not try to guess. >> Instead make it a simple rule: if aminsert is called, then >> aminsertcleanup must be called afterwards, period. >> >> I agree it would be nice to have a way to verify, but it doesn't seem >> 100% essential. After all, it's not very common to add new calls to >> aminsert. > > This thread is listed as an open item. What's the follow-up plan? > The last email of this thread is dated as of the 29th of February, > which was 6 weeks ago. Apologies, I got distracted by the other patches. The bug is still there, I believe the patch shared by Alvaro in [1] is the right way to deal with it. I'll take care of that today/tomorrow. [1] https://www.postgresql.org/message-id/202401091043.e3nrqiad6gb7@alvherre.pgsql regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company