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 1tETgg-007YVA-Dm for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Nov 2024 13:27:07 +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 1tETgf-008d20-4G for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Nov 2024 13:27:05 +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 1tETge-008d1q-Ma for pgsql-hackers@lists.postgresql.org; Fri, 22 Nov 2024 13:27:04 +0000 Received: from lahtoruutu.iki.fi ([185.185.170.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tETgb-003HEA-AI for pgsql-hackers@lists.postgresql.org; Fri, 22 Nov 2024 13:27:04 +0000 Received: from [192.168.1.110] (dsl-hkibng22-50ddb7-241.dhcp.inet.fi [80.221.183.241]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by lahtoruutu.iki.fi (Postfix) with ESMTPSA id 4Xvwqj5GsCz49Q4q; Fri, 22 Nov 2024 15:26:57 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1732282018; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=JCaEMp98vsmUXk2IGJRDybB1P1iPI61QzB78h7RGBt8=; b=TiE8aJlcN6y+Yq4xyFVWNU/wrnhXVR2DbZAwCAg6VVN2H5MSEjt67boGoxSf6v0VT1iEGg +MdylmEfaMzr8MUvSgE/0/KYwLpp6yaKwg8Ov1z57x7xBVrOcn1zt2l50cbjy5uXs3yjqA J6bW+Xbndc2DGmdictTPkoreLGr39W1GIfMFRp/DxFWpWb8avZO7SR7PQEBqr3+372jsXp jtX5eyFCQZhaGU6/WYzbTXIF3VoPQA/Ww0GhcFEkOMthIfo3nwJfFCEPcmGff3RYSnZYnV M95aKo3/mtt197OdA8/SfK8dMLKlTdaUGzK9WzxmPnqsA0NWElILL1fCyIeqtw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1732282018; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=JCaEMp98vsmUXk2IGJRDybB1P1iPI61QzB78h7RGBt8=; b=GM8u4D/mJDh0l2w6wreuK23kY6shOPt0BLc1G/PyK1ubBFx9exjmam1zDHqfZnHSVt1xGk tiAPNNzrkQvagjNQoVu0kI0lm8dxa9DE4Sxgd5THN8zxaNxDZdk0EpYLLGVgiIdjBwp3HE nBRpC6ErMP95yxPG3wXf22Qh7YXCWTygyv7U48QW75E8W8PE3LafEkO+OtlxauRPqxSEGS kZ4WfbVguY1udOstmxis/9SmZVuCK4CAD5hkPpvuCdcCF8C775FYGS+Ps++91PH4PBTJz6 Lc2gfa0musu85NRTauqZmPsvLGMqc665BpeZkeXbLQq0yHGC6O8rTUGZYh5HZA== ARC-Seal: i=1; s=lahtoruutu; d=iki.fi; t=1732282018; a=rsa-sha256; cv=none; b=NGoB98NAl4+qPkeKWh1KQl08TlRUnr8qbjZZj0VxO9GmagqN9T4ska2hkbqrMIWplsqm3e kSTRDRSBdrClUIUsy+ujYJA9YSaqFJsapp4OVaCC8IquNXy6N/uditMdsI5BUsvc3HfAbt 1i1lEeyIG3EgnsclQ5iDPuEp9EqXCTLk7tcnlapcMU+BqUZBBXJJrESbz3l8wOD95epkMH Dj66rTr5MseiP1Vl2ojZYLVdmQtgnPnN32a5oinGjDcz9rKhyKMpnVeYlTc73wA8FFhmGL F7Y39fFNOy7WL7wVK4LxxrXQn+0W84Ibgy4riaciCSPysxX/95r+mVfZNSXgAg== ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi Message-ID: Date: Fri, 22 Nov 2024 15:26:56 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Changed behavior in rewriteheap To: Matthias van de Meent , =?UTF-8?Q?Erik_Nordstr=C3=B6m?= Cc: PostgreSQL Hackers References: Content-Language: en-US From: Heikki Linnakangas 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 On 22/11/2024 15:02, Matthias van de Meent wrote: > I think I'd go with a patch like attached, where the bulk writer > registers that it started with .relsize pages in the relfork, and use > that for smgrextend() decisions. It now also records pages_written as > a separate but accurate value. Looks good to me. Eric, can you confirm that Matthias's patch fixes the problem for you? -- Heikki Linnakangas Neon (https://neon.tech)