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 1uBMDW-000YwN-2N for pgsql-hackers@arkaria.postgresql.org; Sat, 03 May 2025 23:24:22 +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 1uBMDU-00GdeE-Rz for pgsql-hackers@arkaria.postgresql.org; Sat, 03 May 2025 23:24: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.94.2) (envelope-from ) id 1uBMDU-00Gde6-G4 for pgsql-hackers@lists.postgresql.org; Sat, 03 May 2025 23:24:20 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uBMDS-0001WM-0C for pgsql-hackers@lists.postgresql.org; Sat, 03 May 2025 23:24:19 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-3105ef2a071so32816401fa.1 for ; Sat, 03 May 2025 16:24:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1746314657; x=1746919457; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=x1312ldPhDD6UJkzwMRo89wDf9urt3Fos/ujtuI7AOA=; b=GALsuqZMtMUV3NRVR4VdV2Jpix69YFFi1XWgOlFZ2UIG5NkWA+tTAeqxPIGFR3qtyR kqoNzEuEJUMuQHSSg3vDiQyVzAcAvOYaF/pKB6ydzEHgDL163VsdYCau0E0PDUWt6CP8 wkumKz4rCU7nfY2Ma4SIGxPRUTqOnm8VBo/3HqEfFqP30A2tSS2GangUQ5lHlcLEproF yKF4G82g7WtQ04mzlwhcD1bgznwZ9t47wL6/DKnX179GMrQcNBqRGpjgvD5f94z9Ydtk qoOy09g7KcRM0Z8CBwDMbJ/UhcFmRvPV0MqNEy9CynbwdIEZzgzysM5dAbp1At/nq1Hk sOgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746314657; x=1746919457; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=x1312ldPhDD6UJkzwMRo89wDf9urt3Fos/ujtuI7AOA=; b=jGozpvvJ5JTfQGJX/8urHZQeaSD3tLP3YVarE41678mjXgCBGRTgWpliiFpYg9JMyD FNQB+zlxN87OL2U9UKCcM2EenZryl7Bl2ur+UluZs84/faMWn4Y9vdHb6C9Pq6CpFYZn IqKA0ZJYfAbG5l4bNeO/WUNioofTPjAxvxt+uNEyj9xpgb1Gnrs1ayGUpr8Ti50lbAVZ bo6I3x/3L0h86hU9VXFIofQDLO9QzxNt1xVP+nIp9Mvs4SRE3dRqntgl4Tuz6ffp+f0s H7bOTUqBnZtfW0o4pqVA+fR1rVnWYbX0z4Q4us/MHyxRenlvsboOW/gIxbiaPqwCxHq1 5hAg== X-Gm-Message-State: AOJu0YzoQh9SiGWJHzAPQio8IET44tBc115L57/1cakC1x7J9wk7NsCU G536a0FQGEsuky/BkWV4EPoTJDGERc89WYyZs9ZXUsAf+hvzLevQ X-Gm-Gg: ASbGncspTyRL+oKv0b8NPQ+ioXjI/qQ+pgnIhmGgRslV9U4Vh9dC60EvBzvdIO1AMhY hX7DieD7qi8s2eBjTheMM0fueS0Jfo68xnYTTrZ0eA0W6yZ6lqxixtDp04pOcoOW9YAsblVcGrm 0JVBXUIiUJJNZRgojXDPld28anYMUbCU/5FCzq0IqX3FygFYmWHbOSmIBMyF1y2qLhI3Jw9dcfk hL0GuQnTwh0U5+FFTpDzOm87Yo65ftN6RcbaWbPDwFIvj7FC44SyR5KZD2YNyZa1FG8HO/QBTYP gLFyFwfLV3NC30kk/kGxNWsZwfr2RULvEQ5MtHR9w54JOZCda0nmJYoX+LyjiTLpG7umveXEyng jezx2uiK5eMchMRCYlyjmiq0= X-Google-Smtp-Source: AGHT+IEfeCAvf6D9dcdaxFYnk803i4joiil8T/iwKd1Cxy3asjQTaCF0BOPUB8buqu8UC2TTTzitxw== X-Received: by 2002:a2e:a906:0:b0:30b:ee81:9622 with SMTP id 38308e7fff4ca-32351f22ccamr6133241fa.31.1746314656743; Sat, 03 May 2025 16:24:16 -0700 (PDT) Received: from [192.168.50.231] (broadband-188-255-2-52.ip.moscow.rt.ru. [188.255.2.52]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-32029017825sm9675171fa.40.2025.05.03.16.24.16 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 03 May 2025 16:24:16 -0700 (PDT) Message-ID: Date: Sun, 4 May 2025 02:24:16 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: PG 18 release notes draft committed To: Bruce Momjian Cc: PostgreSQL-development References: <5984af13-423d-41b0-8081-2f7000cfc5b7@gmail.com> Content-Language: ru From: Alexander Borisov 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 04.05.2025 01:47, Bruce Momjian wrote: [...] > Given the performance numbers above, which were not in the commit, maybe > I should add it to the case folding item, and add his name as a > co-author. > I'm not a co-author, I'm the author of my own algorithm that significantly improves PostgreSQL code. The author of casefold() is Jeff Davis (and in general, as I understand, Jeff is responsible for Unicode in Postgres). I only suggested how to significantly improve the storage of Unicode Case data and provide fast access to this data. In other words, I improved, accelerated the algorithms. Because of which the functions lower(), upper(), casefold() got a significant boost. -- Regards, Alexander Borisov