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 1wDRfS-002zBr-2v for pgsql-committers@arkaria.postgresql.org; Thu, 16 Apr 2026 18:42: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 1wDRfQ-006e3K-2p for pgsql-committers@arkaria.postgresql.org; Thu, 16 Apr 2026 18:42:20 +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 1wDRfQ-006e3C-1k for pgsql-committers@lists.postgresql.org; Thu, 16 Apr 2026 18:42:20 +0000 Received: from mail-dl1-x1232.google.com ([2607:f8b0:4864:20::1232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wDRfO-00000001M65-02wd for pgsql-committers@lists.postgresql.org; Thu, 16 Apr 2026 18:42:19 +0000 Received: by mail-dl1-x1232.google.com with SMTP id a92af1059eb24-12c555f886dso650884c88.0 for ; Thu, 16 Apr 2026 11:42:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20251104.gappssmtp.com; s=20251104; t=1776364937; x=1776969737; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=ESsdxg/rq3WCLEFCMIaeZz0rWnaKxYEnudCBlZmOl5Y=; b=BZG6BRFSTLXYbrULQkeqIJ3UmF8HjrpBxb/17qi57wMRap4x3EvrQEGec4hEqWhumJ eJ8PlirEl0IrCZmKlhgggEZyzHb+2mxG8I8lEGl6u1jLXxgA49yE7AHQASoQB0UaAz0x R20/Lk+Aw+5jDXE9Djwxyu33pQQ6cC0jOWJ97Gc0jjPCXC1Fe9UZ4i4+RhCydV2DXrz4 Z18VbsJ/Rl9XPl8RNLPtCRy+pZw3l9ECYYPW6nBeQt7ovE7X9HApqs2EGkRqvITGZCaI +K+DePsDVITgxapgVyRt+gssalo2ObYdrFsG2T8sPLP0rd5mnHnpUHpzqZ9FHy6Uco0b 1AYw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776364937; x=1776969737; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ESsdxg/rq3WCLEFCMIaeZz0rWnaKxYEnudCBlZmOl5Y=; b=c1QakLw2L4gcIUb2zr5ZqPVyG5PjfNEinYSBb3DGH2XMXcYLWC48C8vqc5Vdpwyrsn lJPExE89zDsnM2jd/J5L/PAT/3OLgL80YD66V9V/XJPTqZ6CLVSQssSFkwCj4ZAkiBQq 5mnZ/p+a6sb8yrL/xC6W1QLIVWcMFtEyBjPzAb4Oj6uXTSJJmSXMQQ2DnePrWbS0+FGw 16Bk6Gf7WbvzUVBhRbcvfFhSreLCrRnzaGPGLGfpjJsayu8nUXmlwJBeuMqqLzTH7Qfa 6KubGKOCLJT1kPgqAngLTd1LADIreKENKMx4GKSuerSL/nsFa8cQuZ1qhQ2dFPG8Tkwy s81g== X-Forwarded-Encrypted: i=1; AFNElJ9i83WRhexVJWg+INLxME3LczwR9kLQWpBjaDJh7rxOrcUnU5eP8/i+mFH6mKQ8S/w6hra10fRSqOytBU9rt+9Y@lists.postgresql.org X-Gm-Message-State: AOJu0Yxko6yhbyo2JhUaOSBcPt4lDe0aTavUSCEoNi9WObrOkf4xN/4i fwHuMRqqRXxQ6Gqo+wKQXJ6FoA6U3eX66kQgBxSkxOKfH9VEmdW4PCZAef7AegTRhg== X-Gm-Gg: AeBDieuwNtMKmvCb870+CCkcOz1pQQmz2NCrZzNm5460GtJJHfzTG3qMyEa1/UnTldi aq9POu93YPzK1D2TONxagmzF5cMhZdQcxGpLqK2tWPiujplZ8jS2XmEf4SCfkLRSO2nYD4fHjUn /pIT9FowLDWRq9HFn0HLyKHQRyB2xvTGw5HiM7e5S+Yto+rbq8k+XaI0lgH+APO1DOlA5XP5zM/ QkSkwEvmKp5BNILz0Mu7nbekw5c41Bznu8uEplox3nN7xEYYdD8EZADK90SuiKKc93q1URifWDd DJ0q0p83dKWbbE7PmuX+0cVtTVsUu1op/rjOlwri7/aywdo9vBnW0ZtNyFYdFLiyxqaDHnXyMOR dtZZW9SI+VpKech6Laut8y+Na2XZU4Ifeiewz2wm50t9qh+JCnRI8OPUTjK0lFAV1FyjYuG3RF8 c2YJSeI2cr+hnh2aLGMWXE4hcMshghn4o= X-Received: by 2002:a05:7301:128d:b0:2da:7e33:9261 with SMTP id 5a478bee46e88-2e2e61e7243mr262675eec.27.1776364936858; Thu, 16 Apr 2026 11:42:16 -0700 (PDT) Received: from [10.10.247.3] ([50.175.226.10]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2de8eb84511sm8441929eec.17.2026.04.16.11.42.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 16 Apr 2026 11:42:16 -0700 (PDT) Message-ID: <2153399092d446bc1137eee5f70ad7af70e9039e.camel@j-davis.com> Subject: Re: pgsql: Perform provider-specific initialization in new functions. From: Jeff Davis To: Andrey Borodin Cc: Jeff Davis , pgsql-committers@lists.postgresql.org Date: Thu, 16 Apr 2026 11:42:15 -0700 In-Reply-To: <9e74ecd519ac5a1a2a5fefec86d261037f3db311.camel@j-davis.com> References: <2FCB31FC-43E9-45F6-9AF4-4E199132B4E5@yandex-team.ru> <9e74ecd519ac5a1a2a5fefec86d261037f3db311.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1.1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2026-04-13 at 14:08 -0700, Jeff Davis wrote: > That > has two benefits: >=20 > 1. Fixes your issue, because C_COLLATION_OID is always available. > 2. Faster than a default collation based on libc or ICU. I didn't detect any meaningful improvement here, probably because most catalog cache lookups use columns with type NAME not TEXT. But this still seems like a good idea on the grounds that, if we are choosing an arbitrary deterministic collation for some internal purpose, we should consistently choose the simplest and fastest one. >=20 > I don't see a reason to backport this, but if someone else does then > I > could be convinced. I plan to commit this soon. I don't plan to backport unless someone sees a reason that it should be backported (and if so, how far?). Regards, Jeff Davis