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 1tt9G0-009Ael-Nj for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Mar 2025 17:55:41 +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 1tt9Fy-00Cfbn-ON for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Mar 2025 17:55:38 +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.94.2) (envelope-from ) id 1tt9Fy-00Cfbf-AQ for pgsql-hackers@lists.postgresql.org; Fri, 14 Mar 2025 17:55:38 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tt9Fw-002qIX-0P for pgsql-hackers@postgresql.org; Fri, 14 Mar 2025 17:55:37 +0000 Received: by mail-pl1-x635.google.com with SMTP id d9443c01a7336-2235189adaeso43044595ad.0 for ; Fri, 14 Mar 2025 10:55:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1741974935; x=1742579735; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=nTCDFD7T7jpuEh/ZJO+J+o9NeossuMl0/3+SGBTpXQg=; b=VLUsYZ9GTsokzD5RohalhDfhGXriHXqMZDyTtun1+XT4n+yMaD7as48yNqjUBgPDj9 Q3Oe5gDFqFr5ZGQ3nj+zLFBUrZRpv3IFKEAdYBWwaodvTXUnfj8zEmYWY5Uk+Q6dawUY R/hlO3nwtdT4Pbjod3IcuIQwuDW393CeO4gxXTcLGPzrl/gd9wLisSGvjT2aeyUHuUIu zFBCgB7V1DL7g5aMfZyBmlh6DSM4483XsCBno9f/CfKBLvtwH0Nb4GLfC1rMrZmWrrkk qOAIrq7Ek+SIPYbtE7oOPIuHt9GWRshiiYUCIujmnasmzy23tBL2F9O+BUpNvbwi5/bO R6mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741974935; x=1742579735; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=nTCDFD7T7jpuEh/ZJO+J+o9NeossuMl0/3+SGBTpXQg=; b=eMuJNnHclgUSQkit+9oENK0KIO8eXYjwse33I+/x3qC6pI4yOz5eVQSq8l/IhZquJD A5/6AIubwAZE1V9t6S3gOAN11r8RuBCQ7oPJafZMWj91nstioJ1XD9/nt3Uk2rU7DYA3 5v2a873tQDHD8lSiLaJN1MMT+JQWa9CeMklb8b4FSs0wxrTIfissgoGbUpvAyw95BBzO V+17UmovvO0Whl1wCLe3cvqDLEZdKsJlZGxZWyba7HSLvA7tLbK7CYTbKXMWfnI288Mu OX372AZ2Hk0jX/V7AD2zmfliOrommJHguG3Mp3Yav0DBt90PpB8xJl/tj8/iO0ugl7YW l8IA== X-Forwarded-Encrypted: i=1; AJvYcCUbAK5XW4F0Llq+0V2Ke4Ulym1P0UpAmbSemXi1Xs0IE06FqSfeFTP06Nb2ccs9BWUQXGoEynQrCSSIxLhi@postgresql.org X-Gm-Message-State: AOJu0YysT/OPkvjLrIWzog4aXyEA8fHaveSCbG8VkoY4tTPOKpSdBY6E udTYiK4cvzIr0Vd+JixcW9zQ7TsBii9ea4pHYY8EadKRz3yjuXMotymYf/+eOw== X-Gm-Gg: ASbGnct/MYCAx/HD3o6O4uYpENK1cMoONknWA65sf7NW6jI7fucENH4fqbWikyooKwZ /I5Zv45QPfur/LOmJSAcbtUwTjVRsQ/fGHVkaIQibX0D+PaxQObyKEfSLbgIrACyNm+g2SYLQ4v SZsncvvqJE00aPZi4+bRwNAGdwPH0gwKoQWFFAFdiBJXDLWelpEr4KrTSRfYnUvuff0X9bS39Vh xKfB5p+thQlEr8TRWPFQf+Hjj8oEfnkXP6X4ogQt90lFrHt13R1W/M1BEgg7C59MMwN70eDEAuc yEb+LRUcVMBU8Y9tiL6nGvgcAF7LtihNPvZyaWbtHkflhCwFEB24jq/bna1q+MO9AcWgIRabghy tu5sZnzjmqfY= X-Google-Smtp-Source: AGHT+IHWsbE3ZOYA/4VBpT/JEuOlZFD0BIrSH1gOg+R/240yhRs276BgARhh1mfKs4GeVYbBUT+RuA== X-Received: by 2002:a17:902:fc84:b0:215:a303:24e9 with SMTP id d9443c01a7336-225e1681399mr45803675ad.3.1741974935078; Fri, 14 Mar 2025 10:55:35 -0700 (PDT) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-225c68bedc7sm31427785ad.104.2025.03.14.10.55.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 14 Mar 2025 10:55:34 -0700 (PDT) Message-ID: <189455a536758894fe1bbff228fe7e38c40c978c.camel@j-davis.com> Subject: Re: Optimization for lower(), upper(), casefold() functions. From: Jeff Davis To: Heikki Linnakangas , Alexander Borisov , pgsql-hackers@postgresql.org Date: Fri, 14 Mar 2025 10:55:33 -0700 In-Reply-To: <90da84b8-8a89-4ae3-a970-120edc5435c8@iki.fi> References: <7cac7e66-9a3b-4e3f-a997-42aa0c401f80@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> <4f3772355e038acd3cfe0be43ae2c1aacae1794d.camel@j-davis.com> <2c10910c21b16cb9a0e5f67d80589e3acae2b6ef.camel@j-davis.com> <44005c3d-88f4-4a26-981f-fd82dfa8e313@gmail.com> <2a9e520ba41b318df8ed396ef99ed1e3d3e4b5b6.camel@j-davis.com> <90da84b8-8a89-4ae3-a970-120edc5435c8@iki.fi> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-03-14 at 13:16 +0200, Heikki Linnakangas wrote: > Attached are fixes for those and some other minor things. Thank you, I agree and I have applied your changes. Regards, Jeff Davis