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 1topzt-00GG0L-TF for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Mar 2025 20:33:14 +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 1topzu-006P6k-Pd for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Mar 2025 20:33:13 +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 1topzu-006P6b-Fj for pgsql-hackers@lists.postgresql.org; Sun, 02 Mar 2025 20:33:13 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1topzp-000a2y-0i for pgsql-hackers@postgresql.org; Sun, 02 Mar 2025 20:33:12 +0000 Received: by mail-lf1-x12b.google.com with SMTP id 2adb3069b0e04-5495888f12eso1829471e87.0 for ; Sun, 02 Mar 2025 12:33:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740947589; x=1741552389; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id:from :to:cc:subject:date:message-id:reply-to; bh=pFcGy+vRvL/kQqX8fGK7DbD0ouC1BeQpH0cBCx+79wI=; b=IMr8GcQ/TmcRpRl6JlKcPvy6McAlS6nDPKZGR0uD93F8KGFzabF3anz4JV3c/i7q6C U1PX3eC0+kDmZ9F03BURVmz5F3CAqvPYq/eVQQEX71QjMDVnis6eSyXeeL0QTFHXluHL FjLQEAK8Y35i+r0pxhDcJU+06nx7oNQBiwBukh4MMUCg537bJawY8AaKQns/IEBhHokF iC3bWGeCAQ5zGi5wAcJuFM95BghJTeCOjiboRWzJxfiXUsYAS9/2nY2kO+ZyG5af3ffY Pu+EJwgIYL/JDd6f1NzbBRsTrb9Ptpm4wH3RE2I0xLskob8fuUorpow0CazuQWcj39sD Q7bQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740947589; x=1741552389; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=pFcGy+vRvL/kQqX8fGK7DbD0ouC1BeQpH0cBCx+79wI=; b=BTT82u5/vxXG6Eld5AojEcho+4FFufni9pSkpPVDgg4+MLeocy6Ly30UHII3BMCA4H uaI2pFHQ0bXi50QyhlLJCiwdSG/ulcpB1l3Vjidcqxi77wftHAnpOqg5Mq6riQ2yuhEF GRrG821SAut/Al9037LWjkhxbfCDlfetOi2KiciNBQKa4NL+m88EOy3jPLDrmikulxY4 sZe2N+vkzHdow80aVmvTKZ8RuQfDFBOpRXz1cNH+v4dyHuJ1PYeoBCRo0x3Ux5CXACw7 sLOEO/naPqDckNZU0EIHdI1a4CYKjU4/mErJ+9IY9RHrfcDixf17SdV8NDv792wchb4n ameQ== X-Forwarded-Encrypted: i=1; AJvYcCVUgMG4xAN7EvVSF5UN6m3d+LuZLRZkX1bjgeQap/Mq4TQcm2c7cBY71quBNGHDYZi2OCDV/8tzpam4dJjK@postgresql.org X-Gm-Message-State: AOJu0Yyje/D+at99/1GMQQLOHJAASJ8nZ3y5+1BfVsV3RwB5cPzAo4mZ IxRqQJyIO7oPCtORJHEf6zltgnnJVduxEZK2oFUoPSW1lKjkALXv X-Gm-Gg: ASbGncs3dnmdtwiMI1Q5Vt2rmE+2QmXtdMLaHOliC7SHCsZ2Lgj4x+3b5m4CMKdJ8K2 946hCRUuhtAyE3h314f1gIr222+1Z0sxmkkKfdUjZSzm2KNFIabRt1fd6af0otPaDh5xwKSufHD m4zy2t9JyvxFrNCsh98NIBAXM/PGTnuEETxOUO8NVGsxdzxnqy+iUC2dk/0dKFDWeg0UZedYLU6 v4Xx9bSMObcxvtgPd+xBXrP0FRxSqxsDwyAy1sZviZ1XOhzQMBanJXx1b8TsVif47HXGamlIVtP 6HjYL1F8WA7NjpSFWNICFoDT2m895FlWPoiWMHp6gwmXiah1LjTShXI+puREvT364cXAqiwQJ0K Cg5MntpouJlWhZXiZ/P7msMQ7wcQ= X-Google-Smtp-Source: AGHT+IEfgIYjojb+Vz1F1syVtbaO+bJSDt3kOAJY0vY9vuTqn8DNAtwPvk8MT3NEtbCbMLoM7GayCw== X-Received: by 2002:a05:6512:1596:b0:549:58db:6e9c with SMTP id 2adb3069b0e04-54958db745amr2468920e87.39.1740947589237; Sun, 02 Mar 2025 12:33:09 -0800 (PST) Received: from [192.168.50.127] (broadband-188-255-2-52.ip.moscow.rt.ru. [188.255.2.52]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-54962196361sm264488e87.214.2025.03.02.12.33.08 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 02 Mar 2025 12:33:08 -0800 (PST) Message-ID: Date: Sun, 2 Mar 2025 23:33:07 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Optimization for lower(), upper(), casefold() functions. To: Jeff Davis , Heikki Linnakangas , pgsql-hackers@postgresql.org References: <7cac7e66-9a3b-4e3f-a997-42aa0c401f80@gmail.com> <2a1b632e-4531-43cf-a6d9-51cc1a271dc1@gmail.com> <7ab9d255-d7c0-4841-96c3-ed3ce9aa4abd@iki.fi> <12956299-1496-4455-b3ab-299cc0a87d7c@gmail.com> <340f2451-cd76-487b-a1e4-0f0a2fe91fba@gmail.com> <3ffb8b75b26e76624668c0883cac7886468c5d07.camel@j-davis.com> <5cf176fa-44b9-4019-b9b7-ee902352a844@gmail.com> <3080de9bcce916cf8720ac197f634e381c4de564.camel@j-davis.com> <1e3f4f6f-9b12-4109-b0d2-a4c52b5064f8@gmail.com> Content-Language: ru From: Alexander Borisov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 19.02.2025 01:56, Jeff Davis пишет: > On Wed, 2025-02-19 at 01:54 +0300, Alexander Borisov wrote: >> In proposing the patch for v3, I struck a balance between improving >> performance and reducing binary size, without sacrificing code >> clarity. > > Fair enough. I will continue reviewing v3. Did you have a time for review this? I'd like to continue improving Unicode in Postgres, as I previously wrote, next in my plans are Normalization forms, and more. But now I am blocked by this patch. -- Alexander Borisov