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.96) (envelope-from ) id 1vVBAQ-00EwJ9-0v for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Dec 2025 16:11:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVBAP-0011kq-0w for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Dec 2025 16:11:22 +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.96) (envelope-from ) id 1vVBAO-0011kY-2u for pgsql-hackers@lists.postgresql.org; Mon, 15 Dec 2025 16:11:21 +0000 Received: from lahtoruutu.iki.fi ([2a0b:5c81:1c1::37]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVBAN-000oIm-26 for pgsql-hackers@lists.postgresql.org; Mon, 15 Dec 2025 16:11:20 +0000 Received: from [10.0.2.15] (unknown [130.41.208.2]) (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 4dVQ625B8pz49Q7b; Mon, 15 Dec 2025 18:11:06 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1765815067; 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=hLzcXoy4Ll9+pQxM6wAOqJD8ghiAtZke3vWzRS/SRKc=; b=czzw5W9RYn9bI6DIXHA1vJikuBY+NacQBMvoU7gv1aQz85EEd+iFtklW13IhH1XvQmkDgp kVZy5We7LVCNybhYt3IPfFULhno3Dj/dIFZh1FVqZ2fuyp8EJOASfH17C+DOtjZy3H8H0p F7gtQ7j6WREZUx93aMYpegml0/DhWqG2b1o04ndEkVVySeG0Iz88wJy1JRfEdMxvLROCpv NFRS1wqWAjE39XQJocoZLxDKUlEVCpdN27w77g/g2GTwGD/lIsK3MTp+5EIBMR/yS2TOA8 0w9BmztCXouwcBbyXBV/2xRppOQGXP5ir4kGhuB1NzJTo0iYk07EZE3P9ruyiw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1765815067; 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=hLzcXoy4Ll9+pQxM6wAOqJD8ghiAtZke3vWzRS/SRKc=; b=weyIXNWXCHXId15ULV4q60KVKPazHKst9tyVJKbUUmDzil9QJCxzynOWWaRXWm1luWPjPB gIqVLJ3Sl5oc79uqSkmC41F2H1lmJNj5HN5WYl+EAlASYVsHomFyo0w/OxEXbqkv3yC4J3 GLq6ME6GM55m99W3M33fuqi5zURSxMeV+8KLO3BXYqA56nICP/spAFEt7aRpKHLkuDl0nk DfU4QikKeHXHSCiqZHF7wt0tk+ncyHjGlmYkcXVLRQcwn7gBL+nI/eKO8UGcEMDViNiDSs LMiD+fPlcm8Cg0sC3ELHcwklvx1UfnUoZ7nySDB0T6wqq5Q5TjcCCU71ZsjZfA== ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Seal: i=1; a=rsa-sha256; d=iki.fi; s=lahtoruutu; cv=none; t=1765815067; b=A3UsOceO63oBk8ZCZDMX43FKspuiKvWmqG4HpRG2arML7FdEliAFw/dago6ILpuaVZ0MPv rXjJpXsihmpn8rtt8VMBb5sDBsLegs8YzlrN+30Nv7o8y6OK5EWOozk1SgT1C0dCGXQEGo VBHg9LGHxyBJfSh75j24QKMVZY6XBr/7brTBH9uZBrQHOoDIrNw+aolnzfmGOPcn0mMKc5 CL2gCnVS8BpnsKCjRuLwsIYspBcMkrh4JmDuaIAP0DxyT1OqeunGE6NSJtVqMnZsOwQ7U4 RgFQtEPdC1yHXEnGEj7B2rZOScOIchr1eHobT8YeDFnRGDYhwBaKqF1GNkkIvA== Message-ID: <6dc0880b-15fb-42cf-abfc-62d9d80dd287@iki.fi> Date: Mon, 15 Dec 2025 18:11:05 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: POC: make mxidoff 64 bits From: Heikki Linnakangas To: Alexander Lakhin , Ashutosh Bapat , Maxim Orlov Cc: Alvaro Herrera , Alexander Korotkov , wenhui qiu , Postgres hackers References: <36531c0e-292c-409d-bbc7-a252cf6e910a@iki.fi> <54aa8f65-f0e4-4464-b543-e0399c1cab1e@iki.fi> <4a9dda70-0af7-41a4-9636-b168f2fc48ef@iki.fi> <46cc45e9-fddd-44bc-bcb3-96889aafd921@iki.fi> <6c298bc4-7029-4c1d-bf16-3e094842ce32@iki.fi> <2c62322e-a0e3-49cd-b369-370718a8efd8@iki.fi> <3624730d-6dae-42bf-9458-76c4c965fb27@iki.fi> Content-Language: en-US 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 15/12/2025 16:31, Heikki Linnakangas wrote: > On my laptop with jit_above_cost=0 and jit_optimize_above_cost=1000, > like on those buildfarm animals, the multixid generation workload runs > in under 10 s. I suppose it could be 20x slower on a slow, busy system. > So the straightforward fix is to bump up the timeout. I bumped the timeout to 4 * 180 s. I also added a few progress report notes to the test output, so that we get a better picture of where the time goes. - Heikki