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 1w7wkQ-0003nn-2k for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 14:40:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7wkP-000ZiS-2P for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 14:40:46 +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.96) (envelope-from ) id 1w7wkP-000ZiK-1Y for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 14:40:45 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w7wkN-000000001qJ-1ghE for pgsql-hackers@postgresql.org; Wed, 01 Apr 2026 14:40:45 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 5AA805A4475 for ; Wed, 01 Apr 2026 16:40:43 +0200 (CEST) Received: from s934.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id 4219B5A386A; Wed, 01 Apr 2026 16:40:43 +0200 (CEST) Received: from localhost (unknown [172.22.191.6]) by s934.loopia.se (Postfix) with ESMTP id 3FFA67CEA68; Wed, 01 Apr 2026 16:40:43 +0200 (CEST) X-Virus-Scanned: amavis at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.2 X-Spam-Level: X-Spam-Status: No, score=-1.2 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1] autolearn=disabled Authentication-Results: s474.loopia.se (amavis); dkim=pass (2048-bit key) header.d=proxel.se Received: from s981.loopia.se ([172.22.191.5]) by localhost (s474.loopia.se [172.22.190.14]) (amavis, port 10024) with UTF8LMTP id 1L5uSb4Gyid4; Wed, 1 Apr 2026 16:40:43 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: andreas@proxel.se X-Loopia-Originating-IP: 147.28.75.140 Received: from [192.168.0.121] (customer-147-28-75-140.stosn.net [147.28.75.140]) (Authenticated sender: andreas@proxel.se) by s981.loopia.se (Postfix) with ESMTPSA id D271122B16B4; Wed, 01 Apr 2026 16:40:42 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=proxel.se; s=loopiadkim1707418970; t=1775054442; bh=HL0r6kdLfIMuQf0X/SqdaAbgKu8nNPbXAXA9vHr1gXc=; h=Date:Subject:To:References:From:In-Reply-To; b=A9wLLEemR8bficKK+NUlJir3sQ/Z/Gh2GtM7E/J6UwPK/jtiQA+eGeP4qx7jdGjtE CCBs0SQZAksWtMqxH9jwSPgltECVCqYByWDvy/ZntCYG4ZD+aZig3ax6286FOZgSGI gXn+2nEIskYrEwU1ynbHp2dbHeF4zsAyAEBudEXWlG9MlO+BlD9mnjYnRlNcOq3SV0 xxUk7Py5veF6XYP8Rh6OllRoIHFBJht5+JAny/23MVroI+f4HWFA5/jV+vRSI1phDJ XCAJWQhZKYm/VFLCGZC3MX3h3fcwFa9MLYEm22KtxfINRW+m+B/YvLYVB46VFkQSCB /OsK4hYsXO17A== Message-ID: <0d2d725f-d05f-4b04-a98d-939309c1e129@proxel.se> Date: Wed, 1 Apr 2026 16:40:42 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: [PATCH] Add fx exchange support to money type To: Joel Jacobson , pgsql-hackers References: From: Andreas Karlsson 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 4/1/26 9:00 AM, Joel Jacobson wrote: > As shown above, the FX lookup takes about 38 ms the first time, after > which the session cache makes subsequent lookups cheap. Thanks for the patch! It is very late in the release cycle for 19 but you could add it to the next commitfest. Always nice to see some interest in the money type, I have some own ideas for it for PostgreSQL 20. -- Andreas Karlsson Percona