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 1uhwii-005nth-Fj for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Aug 2025 20:51:16 +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 1uhwig-009OTz-B3 for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Aug 2025 20:51:14 +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 1uhwig-009OTr-1Q for pgsql-hackers@lists.postgresql.org; Fri, 01 Aug 2025 20:51:14 +0000 Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uhwiZ-000FRk-0M for pgsql-hackers@postgresql.org; Fri, 01 Aug 2025 20:51:12 +0000 Received: by mail-lj1-x22c.google.com with SMTP id 38308e7fff4ca-3324e2e6f54so7840231fa.1 for ; Fri, 01 Aug 2025 13:51:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754081465; x=1754686265; darn=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=V0DaEOZchFxUXxB4n5sl3DX1rYu5tI/I4yr5suA+U7w=; b=huBJBpVOnv1M77U3E7kUfEn2i4C6j/HvYaaMnxm03BNQMIMeQ7aADh3S9YcCKKoAij p3HpFW0u0mcZPYnBGLxOI3iMuf5lDq1Lg8faQqBQlWLPCrlHixhgDkkzUXHsmEAyYJJs 0Mwwe28sV3+Aada9X1KJD3R2QEfYM6US2SEtBIebnQKhR2umjg78SPtQZs0K8CoDe5bf dNUBs8vR0+EZyR1GCp8d79R+2PMgNpiwoP+qqdNRFuLudTcArfTrBm8rJCNgmMfeAioZ uLYrHHPmbI9RNxl7udveriIiS8H8w+qnf1u8Vd/g8e3lk2LHX4tznbaLgwtlvVXdW4TJ Uj6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754081465; x=1754686265; 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=V0DaEOZchFxUXxB4n5sl3DX1rYu5tI/I4yr5suA+U7w=; b=DB6vAHWk60fE/pwUmhqv9YTRPEPnibJazn9CWg+W2buRaR83KydH6y/5X6mdT+U3xh pWVegBYQfIhf4fierLTAauZyq/irThKOSmCXMCyvcCEUG4YJE1ErVeRxpy7A8QK1ttxa NlU/D/4fzaGB4B4QILa6MHCKgXzULicg7F/jvWFRVniSWOW68IlUyvOCoTnNspbyL8am RDwA8FVelAoWnAJSqnmMjQhSrpxTQ3ukfZhN7Xl5Pz1ertMUnlgXMdm9aCwJ7kVwVJLE AbhVuvjeGJdJBMzTGK3J6QDNk8uTIU6C/eq2P8xDUr1EwUO3wV+qknLuNIeXowIi7sfs KrKA== X-Gm-Message-State: AOJu0YxmoAliB77eo7c/KdyOR/mJJzJcsTbDNMLARuOX8TDaVII3LJu6 i8sQe/N2op5dHVKhlnX9JkRzqKTN7zm5+o09yfsYSkz25hW0MZ/y5lDb+E82b7io X-Gm-Gg: ASbGncu/PxT/wU+zeGFNKENh/3jZ42AfoaPHvxRY7GcBjDdoWpnnGp1QduoQzGPoZms ssbs1IBuQb3TdoGN28mk6uridlKG0RDWU/aIM/w+ypUmizOx6Keb6P4ONCpPSz6PhmUSVz47sB3 CNSx/6kt6slrANouuyWn71qMNZnuht1Q0TL7xyDM6WRO3DtsMoJ9fGyXCW4Uu8WWytCtcprFpGx cXxOtIx2QX9lSps562qEe8hjtIJECreKA3B3zljZaO6bD2GzBDReq075JiwpYAn0/Ase2QSnMtz a9/e2k5KX0VNPSfKfJaoo8wlxSrI05ZOWKv5M8MDwIaMu1QrxvS9QUvsecWXkvh3cKvy4yScv/t NalByw/mvGOCRg9PoJrmgyYcqzf84YSQmL23U0+cLki36HBy3OpXntF9zEHwy0KQwym2T5Jn6b6 YzTRceguR3 X-Google-Smtp-Source: AGHT+IEFvjrHDgtjv13h/Yu+3o17khCyn8a7a09wLIUQnI2II1xBT9mUJYDzyS3niJmHlSYB9W6eQQ== X-Received: by 2002:a05:651c:1b8f:b0:32a:6cab:fd75 with SMTP id 38308e7fff4ca-332559f5b7dmr2400331fa.11.1754081464918; Fri, 01 Aug 2025 13:51:04 -0700 (PDT) Received: from [192.168.50.231] (broadband-5-228-116-129.ip.moscow.rt.ru. [5.228.116.129]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-33238271bdfsm7001101fa.6.2025.08.01.13.51.04 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 01 Aug 2025 13:51:04 -0700 (PDT) Message-ID: Date: Fri, 1 Aug 2025 23:51:04 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Improve the performance of Unicode Normalization Forms. To: Tom Lane Cc: PostgreSQL Hackers References: <844d3dd7-2955-4794-95d1-7f4c13cb89fc@gmail.com> <4211ffd7fe154c4af693b98d78f4a3689ce8cc30.camel@j-davis.com> <16f87504-f174-450e-93cc-2db1074522bb@gmail.com> <96c54fc3dde2ebaccafbd1ffa29b8be1005c8b8c.camel@j-davis.com> <677cde50-6d64-474b-9ba8-bab380a111b3@gmail.com> <599663a8d5948243bd87bf55a4f76bbb4a51a6e8.camel@j-davis.com> <85f2a36f-f70a-4667-be48-49b652457295@gmail.com> <088432f3-a3a9-4c40-8295-6c687c25d651@gmail.com> <9db10eba-a756-4b3f-9550-83cab1a1a39e@gmail.com> <2492580.1754077022@sss.pgh.pa.us> Content-Language: ru From: Alexander Borisov In-Reply-To: <2492580.1754077022@sss.pgh.pa.us> 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 01.08.2025 23:37, Tom Lane пишет: > Alexander Borisov writes: >> I'm new here, so please advise me: if a patch wasn't accepted at the >> commitfest, does that mean it's not needed (no one was interested in >> it), or was there not enough time? > > It's kind of hard to tell really --- there are many patches in our > queue and not nearly enough reviewers. So maybe someone will get to > it in the fullness of time, or maybe it's true that no one cares > about the particular topic. (But bug fixes and performance > improvements are almost always interesting to someone.) > > I recommend optimism: as long as *you* still believe that the patch > is worthwhile, keep pushing it forward to the next commitfest. > We used to do that automatically, but we have started asking authors > to do that themselves, as a way of weeding out patches for which > the author has lost interest. Thanks, Tom! I always choose optimism. I've been in open source for a while, and this is the first time I've seen this approach. I have a plan to further improve Postgres performance in terms of Unicode (and not only) (which is kind of the foundation for working with text). I don't want to overwhelm the community with patches. I take a systematic approach. Once again, thank you, Tom. The community's approach has become clearer. -- Regards, Alexander Borisov